Hi, I'm having an issue with a DAX formula limited to TOP!%. But produces more that 15 lines. Could it be because I have a filter on the PIVOT TABLE for location. But need to add it to the measure?
tblLocation.Loc#
The measure below should provide me with the TOP 15 Brands sold for the day, based on units sold.
TOP 15 BRANDS UNITS SOLD:=VAR RankingContext =
VALUES ( 'tblInvMaster'[BRAND NAME])
VAR TopNumber = 15
RETURN
CALCULATE (
[SALES UNITS SOLD],
TOPN ( TopNumber, ALL( 'tblInvMaster'[BRAND NAME]),[SALES UNITS SOLD] ),
RankingContext
)
Thanks
tblLocation.Loc#
The measure below should provide me with the TOP 15 Brands sold for the day, based on units sold.
TOP 15 BRANDS UNITS SOLD:=VAR RankingContext =
VALUES ( 'tblInvMaster'[BRAND NAME])
VAR TopNumber = 15
RETURN
CALCULATE (
[SALES UNITS SOLD],
TOPN ( TopNumber, ALL( 'tblInvMaster'[BRAND NAME]),[SALES UNITS SOLD] ),
RankingContext
)
Thanks