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.