Rankx with parameters

[szymonswiezyfg]

Hi,

I have problem with sorting table using rankx with parameters.

I use parameters table with 15x different rankx measures but when i change parameter on slicer it's always be sorting in different way. 

How can i solve this?

Example measure and table with slicers

Ranking liczby transakcji =
RANKX(
    ALLSELECTED(dane[Podmiot Nazwa]),
    [Liczba transakcji],,DESC)

[v-yifanw-msft]

Hi @szymonswiezyfg ,

Based on the information you have provided, you need to provide detailed data to solve the problem. However, I can provide you with the following Measure attempt to help you solve the problem:

Rank =

VAR Selected =

    SELECTEDVALUE ( Parameter[Column Name], "Default Measure" )

RETURN

    SWITCH ( Selected, "Measure1", [Rank 1], "Measure2", [Rank 2],…, [Default Rank] )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}