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