Forum Discussion

theo's avatar
theo
Icon for Helper III rankHelper III
5 years ago
Solved

Rankz measure with countrows always return 1

Need help on using RankX measure that always shows as 1 in visual. tried so many iterations provided in this forum but cannot really the right DAX.  Hope someone can help. Measure = var _countif=...
Need Help
  • theo's avatar
    theo
    5 years ago

    found the correct expression.  Thanks all for nudging me to the right direction.

    RANKX(ALL('28Jun_1973'[RCode]),calculate(COUNTROWS(FILTER('28Jun_1973',[RCode]='28Jun_1973'[RCode]))),,,Dense)

     

theo's avatar
theo
Icon for Helper III rankHelper III
5 years ago

Hi aj1973 ,

here you go:

 

ID     RCode RankAdvance
1000AAAXYZ
1001AAAZY1
1002AABXYZ
theo's avatar
theo
Icon for Helper III rankHelper III
5 years ago

found the correct expression.  Thanks all for nudging me to the right direction.

RANKX(ALL('28Jun_1973'[RCode]),calculate(COUNTROWS(FILTER('28Jun_1973',[RCode]='28Jun_1973'[RCode]))),,,Dense)