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.
Hi,
I have been struggling in getting Rank Dax logic work for my scenraio and looking for someone who could help me in achieving the result
Scenario: I have a measure which is Percentage and i want to create a Rank on that Percentage measure and that Rank should be dynamic based on user selected filter column from two different dimension tables.
Below mentioned is the Dax i have coded, but its not working as expected and i am getting same rank for different values.
[AP Case Impact Score YTD PHC] = Percentage measure
Rank:= if( not ISBLANK([AP Case Impact Score YTD PHC]), RANKX(ALLSELECTED('CenterUp Heirarchy'),[AP Case Impact Score YTD PHC],,ASC,Dense),BLANK())
I am looking for above Result, but i am getting same rank for different values.
I have been trying hard to achieve the result but couldnt succeed and egarly waiting for answer and help!!
Solved! Go to Solution.
Hi @Pravallika05 ,
I created some data and used your formula then I got the correct result.
It's better to share some sample data to us.
Best Regards,
Jay
Hi @Pravallika05 ,
I created some data and used your formula then I got the correct result.
It's better to share some sample data to us.
Best Regards,
Jay
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 |
---|---|
119 | |
105 | |
78 | |
74 | |
52 |
User | Count |
---|---|
145 | |
108 | |
107 | |
90 | |
64 |