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)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Measures : =
VAR measure_rank =
RANKX (
ALL ( '28Jun_1973' ),
CALCULATE (
COUNTROWS ( FILTER ( '28Jun_1973', [Rcode] = '28Jun_1973'[Rcode] ) )
),
,
,
DENSE
)
RETURN
measure_rank

 

 

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

    Thanks Jihwan_Kim , however, when I used the expressing in visual, the processing is too slow.  10minutes, still have not completed.

    Any variation of the expression you can suggest.

    thanks.