Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |