Rank function not giving distinct values when same value exists

[harib]

Hi Everyone,

Can anyone let me know how to get distinct values when same values exists in the table. In the below table i have used Rank function , but not getting distinct values for the same values, due to that i'm not getting 100% in the percent column. 😞 

Rank = RANKX(ALLSELECTED('Table'[Field]), [Record Counter])

Thanks in advacne 

[v-lid-msft · Accepted solution]

Hi @harib ,

We can try to use the following measure to meet your requirement:

Rank = 
IF (
    ISINSCOPE ( 'Table'[Field] ),
    RANKX (
        ALLSELECTED ( 'Table'[Field] ),
        RANKX ( ALLSELECTED ( 'Table'[Field] ), [Record Counter],, ASC, DENSE )
            + RANKX (
                ALLSELECTED ( 'Table'[Field] ),
                CALCULATE ( MAX ( [Field] ) ),
                ,
                DESC,
                DENSE
            )
                / CALCULATE ( DISTINCTCOUNT ( 'Table'[Field] ), ALLSELECTED ( 'Table'[Field] ) ),
        ,
        DESC,
        DENSE
    )
)

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？

[amitchandak]

Refer : How to break ties in

https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin