Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RANKX by two columns

Hi,   I'm trying to rank my data making use of 2 dimensions that is 'Product Family' and 'Fiscal Qtr' since I need the top 10 values based on the Fiscal Qtr. I'm trying to put this measure on the v...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

 

Rank_WITH_ALL2 =
RANKX (
ALLSELECTED ( AIO_Sample[Product Family], AIO_Sample[Fiscal Qtr] ),
CALCULATE ( [ASP Impact_Latest] , filter(AIO_Sample, AIO_Sample[Fiscal Qtr] = "FY2021Q4" )),
,
DESC,
DENSE
)