QTY sold vs. OH wont link

[sjhc1177Participant Started: 25Replies: 28Total: 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

[tomallanKeymaster Started: 0Replies: 417Total: 417]

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

[Author]

Posts