TOPn SOLD vs OH

[shophoney]

[FONT=&quot]Hi, I’m trying to build a measure to list the TOP 10 models and what our inventory levels are for those items.[/FONT]
[FONT=&quot]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.[/FONT]
[FONT=&quot]This is my TOPN[/FONT]
[FONT=&quot]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
)[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]This is my OH measure:[/FONT]
[FONT=&quot]ON HAND UNITS:=sum(‘INVENTORY STATUS'[OH UNITS])[/FONT]
[FONT=&quot]I would like to see how many units sold and then how many we have left.[/FONT]
[FONT=&quot] When I pull down both measures the list is hundreds of rows. Not the top 10 or 25 [/FONT]
[FONT=&quot]Thanks[/FONT]