Dynamic Rank as Column

[Suhel_Ansari]

Hi DAX Expert,

I Need a DAX to create a Dynamic ranking column based on the country code, I have country short name repeating it multiple time so based on the occurance of this country code I have to rank it, The below formula do the same however when i slice the table based on Country slicer the rank doesn't change, please helpe me out with this issue. Thanks 

Regards

Suhel

[v-yuta-msft]

@Suhel_Ansari ,

So your requirement is to achieve a dynamic column based on slicer, right? I'm afraid dynamic column is not supported in power bi, you need to use measure instead.

Regards,

Jimmy Tao

[Suhel_Ansari]

@v-yuta-msft 
My requirment is I need to change the Rank based on the Country Code selection and I need a Column so i can later use this in the Switch statement to create a group. Thank

Regards

Suhel