Home Forums Power Pivot QTY sold vs. OH wont link

This topic contains 1 reply, has 2 voices, and was last updated by  tomallan 3 years, 5 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #18146

    sjhc1177
    Participant
    • Started: 25
    • Replies: 28
    • Total: 53

    Hi, I’m trying to build a measure to list the TOP 10 models and what our inventory levels are for those items.

    I would rather use CUBIC formulas but since the list of the TOP items changes each day I am limited to a Pivot Table. I could have another pivot table and use a vlookup. But that doesn’t seem as efficient.

    This is my TOPN

    TOP 25 BRANDS UNITS SOLD:=VAR RankingContext =
    VALUES ( ‘tblVendor'[VENDOR NAME])
    VAR TopNumber = 25
    RETURN
    CALCULATE (
    [SALES UNITS SOLD],
    TOPN ( TopNumber, ALL( ‘tblVendor'[VENDOR NAME]),[SALES UNITS SOLD] ),
    RankingContext
    )

     

    This is my OH measure:

    ON HAND UNITS:=sum(‘INVENTORY STATUS'[OH UNITS])

    I would like to see how many units sold and then how many we have left.

     

    Thanks

    #18148

    tomallan
    Keymaster
    • Started: 0
    • Replies: 417
    • Total: 417

    Are you using RankingContext as a bridge table to handle a many-to-many relationship?

Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘Power Pivot’ is closed to new topics and replies.