Forum Discussion

szymonswiezyfg's avatar
szymonswiezyfg
Frequent Visitor
2 years ago

Rankx with parameters

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)
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.