Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

Return text based on max value

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? 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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



1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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