Rankz measure with countrows always return 1

[theo]

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=calculate(COUNTROWS(FILTER('28Jun_1973',[Rcode]='28Jun_1973'[Rcode])))
var measure_rank = RANKX(all('28Jun_1973'),_countif,,,Dense)
return measure_rank

[Jihwan_Kim]

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

[theo]

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.

[aj1973]

Hi @theo 

Can you provide a Sample of your file

[theo]

Hi @aj1973 ,

here you go:

ID	RCode	RankAdvance
1000	AAA	XYZ
1001	AAA	ZY1
1002	AAB	XYZ

[theo · Accepted solution]

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)

[aj1973]

@theo 

Sorry, what am I suppose to do with this!?

I invite you to check out this 

How to Get Your Question Answered Quickly - Microsoft Power BI Community