Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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
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
Proud to be a Super User!
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
Proud to be a Super User!
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
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
Proud to be a Super User!
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |