Dax: need help

[laciodrom_80]

Hi guys,

I've got a table (Table1) where Scenario and Value are two columns (string and number respectively) and Ranking is a measure:

Ranking = RANKX(ALLSELECTED(Table1[Scenario]); CALCULATE(SUM(Table1[Value])); ;ASC;Dense)

In my Report I create this table with Scenario column and Ranking measure

Then I have another measure which gives me a specified ranking (specifiedRanking😞 I would like to create a new measure which returns the corresponding Scenario starting from this specifiedRanking, how could I write a dax expression for this goal?

Thanks a lot for any hint

[Zubair_Muhammad · Accepted solution]

@laciodrom_80

Something like this may be

Measure =
VAR myrank = [specifiedranking]
RETURN
    MINX ( FILTER ( VALUES ( Table1[Scenario] ), [Ranking] = myrank ), [Scenario] )

[laciodrom_80]

@Zubair_Muhammad  

I noticed that if I try to not use VAR myrank, directly using specifiedranking like this:

Measure = MINX ( FILTER ( VALUES ( Table1[Scenario] ), [Ranking] = [specifiedranking]), [Scenario] )

the measure isn't right computed any more...why must I use the local variable myrank?

thnaks