RANKX mesure results

[Digger]

How to rank measure results?

for examle
measure =

VAR sum = SUM([sales])

VAR count = Rankx(sum,sum>=10,,ASC,dense)
RETURN
count

[v-easonf-msft · Accepted solution]

Hi, @Digger 

I made a sample for your reference on how to rank measure results.

Please try formulas like below:

Rank = 
IF (
    Sheet1[sum] >= 10,
    RANKX (
        FILTER ( ALLSELECTED ( Sheet1[Created] ), Sheet1[sum] >= 10 ),
        Sheet1[sum],
        ,
        ASC,
        DENSE
    ),
    BLANK ()
)

count = COUNTX(ALLSELECTED(Sheet1[Created]),[Rank]) 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Digger , What is needed. This is Wrong usage

refer TOPN -https://youtu.be/QIVEFp-QiOk 

Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...