RANKX on Field Parameter returns all 1

[Anonymous]

I wanted to sort my bar chart with Fieldparameter for one axis on the values, but that keeps resetting when switching between my KPIs. So I tried to instead create a RANK measure, and add it to the tooltip instead. However I'm stuck with the measure returning all rows as Rank 1. 

When I return the selected value (_Value below) it matches correctly the actual value, so It must be something I'm doing wrong with the RANKX function... 

VAR _Selected = SELECTCOLUMNS(SUMMARIZE( 'Parameter','Parameter'[Parameter],'Parameter'[Parameter Fields]), "Parameter", 'Parameter'[Parameter])
VAR _Selected2 = IF(COUNTROWS(_Selected),_Selected)

VAR _Value = SWITCH(
    TRUE(),
        _Selected2 = "Measure1 %", [Measure1 avg %],
        _Selected2 = "Measure2 %", [Measure2 avg %],
        _Selected2 = "Measure3 %", [Measure3 avg %],
        _Selected2 = "Measure4 %", [Measure4 avg %],
        _Selected2 = "Measure5 %", [Measure5],
        _Selected2 = "Measure6", [Measure6],
        _Selected2 ="Measure7", [Measure7])

VAR _RANK = RANKX(ALL(Store[StoreName]), _Value, ,DESC,Dense)
RETURN
_RANK

Any suggestions? thanks

[pankajnamekar25]

Hello @Anonymous 

this solution will not work with feild paramter , I had similar reuriment in one of my project.

I connected different page for each metric and slicer user disconnected table and loop that table in rankx measue

Unpivot the Task Columns

Select the Project column.

Go to the ribbon: Transform → Unpivot Other Columns.

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Anonymous · Accepted solution]

@pankajnamekar25 

Thanks for the response, 

I decided to just sort on the _Value variable instead. Gave me the desired result