Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RankX with 2 fields

Hello All.   For some reason 1 RankX formula works but the other doesnt.   Below is Dax:   Product Rank (Name) = VAR CURRENTPRODUCT = MAX('(Dim) Product'[Product_Name]) RETURN RANKX(FILT...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

 Your formulas are calculated columns,right?

If so ,modify them as below:

 

Product Rank (Name) = 

RANKX(FILTER(ALLSELECTED('(Dim) Product'),'(Dim) Product'[Product_Name] = EARLIER('(Dim) Product'[Product_Name])),[Master],,DESC,Dense)
Product Rank (Category) = 
RANKX(FILTER(ALLSELECTED('(Dim) Product'),'(Dim) Product'[Category] =EARLIER('(Dim) Product'[Category] )),[Master],,DESC,Dense)

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!