Help with rankx(); Ties I don't understand the origin of

[ashamsuzzoha]

Hello, I'm trying to run the following simple rankx measure in a table visual.

Undergrounding Priority Rank = 

RANKX(
    ALL('tablename'),
    CALCULATE([Undergrounding Priority Score]),
    ,
    ASC
)

But placing the measure in the table leads to ties I can't figure the origin from, as show below.

Can someone help me out here? Thanks.

[amitchandak · Accepted solution]

@ashamsuzzoha ,

Try like, if this can work

Undergrounding Priority Rank = 

RANKX(
    ALL('tablename'[Feeder]),
    CALCULATE([Undergrounding Priority Score]),
    ,
    ASC
)

For Rank Refer: https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[AiolosZhao · Accepted solution]

Hi @ashamsuzzoha ,

Please try to use the below measure. It works on my desktop:

Measure 15 = RANKX(ALL('Table (4)'[Feeder]),[Your Measure],,ASC)

Aiolos Zhao 

[amitchandak · Accepted solution]

@ashamsuzzoha ,

Try like, if this can work

Undergrounding Priority Rank = 

RANKX(
    ALL('tablename'[Feeder]),
    CALCULATE([Undergrounding Priority Score]),
    ,
    ASC
)

For Rank Refer: https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[ashamsuzzoha]

@AiolosZhao @amitchandak Thank you, but that does not seem to have helped.

Now all the ranks are 1.

[AiolosZhao]

Hi @ashamsuzzoha ,

1. Is Feeder a normal column?

2. Could you please show me the measure of Undergrounding Priority Score?

3. If these columns are not in one table, could you please show me the data model?

Thanks.

Aiolos Zhao

[ashamsuzzoha]

@AiolosZhao @amitchandak 

The Priority Score measure is a weighting of individual rankx measures on columns on my table, as follows:

Undergrounding Priority Score = 

[rank_column A] * weight A + 
[rank_column B] * weight B + 
[rank_column C] * weight C + 
[rank_column D] * weight D + 
[rank_column E] * weight E + 
[rank_column F] * weight F + 
[rank_column G] * weight G

where the sum of weights is 1

so I had to correct the individual rank measures with the code you suggest, and it worked.