Return text based on max value

[M_SBS_6]

Hi, I have the following measure which returns the max value. 

Max_val = 

Calculate(

Max(test[test_%]),

Test[sum] <> {'live'}).

However, withing my multi row card, I get the Max value correctly but against all test[sum]. My fields are test[sum] and max_val.

 On my filters for test[sum] I have top 1 by max_val but that doesn't seem to work.

Any other ways of presenting this please? 

[Anonymous · Accepted solution]

Hi @M_SBS_6 ,
Based on your description, I can't get a good sense of what you mean. According to my understanding, I realized the following steps. Here some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

Create a measure

Max_val_Text = 
VAR MaxValue = [Max_val]
RETURN
CALCULATE(
    SELECTEDVALUE(test[sum]),
    test[test_%] = MaxValue,
    test[sum] <> "live"
)

Put the measure inside the card

Or put meaure and [test%] into multi-row card and set the fliter test as TOP 1 and Set the by value as test%

Best regards

Albert He

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