Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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)
Measures : =
VAR measure_rank =
RANKX (
ALL ( '28Jun_1973' ),
CALCULATE (
COUNTROWS ( FILTER ( '28Jun_1973', [Rcode] = '28Jun_1973'[Rcode] ) )
),
,
,
DENSE
)
RETURN
measure_rank
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
Hi @theo
Can you provide a Sample of your file
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
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)
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
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |