Dynamic Rank based on user selected filter ( Columns from two different Dimension tables)

[Pravallika05]

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!!

[v-jayw-msft · Accepted 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