Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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