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 am looking to create a rankx measure that accomplishes the following:
I have a table with IDs, and some of the IDs are repeated if they are present in more than one location. I need a ranking that will be assigned to each of the rows for a specific ID based on the sum(Amount) for that ID compared to the sum(Amount) for all the other IDs. The image contains an example. The column titled 'Rank' is what I am getting with my current measure (below), but what I'd like is what's in the 'Desired Rank' column.
Is this possible?
Current Measure:
Rank = RANKX(ALLSELECTED('Table'), CALCULATE(SUM('Table'[Amount])))
Solved! Go to Solution.
Hi @mjmar025 ,
Please refer to this measure.
rank = RANKX ( ALLSELECTED ( 'Table' ), CALCULATE ( SUM ( 'Table'[Amount] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) ), , DESC, DENSE )
Best regards,
Yuliana Gu
Hi @mjmar025 ,
Please refer to this measure.
rank = RANKX ( ALLSELECTED ( 'Table' ), CALCULATE ( SUM ( 'Table'[Amount] ), ALLEXCEPT ( 'Table', 'Table'[ID] ) ), , DESC, DENSE )
Best regards,
Yuliana Gu
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |