Multiple validations on multiple measures.

[ittahashi]

Guys I have a challenge for you today, for me is being kind of a nightmare in terms of doing it eficiently. I mean not using an enourmous ammount of nested IF

Lets say you need to create a report with 3 measures already created that are giving you the performance of 3 specific teams:
VAR PSG performance = {Bad, Medium, Good} // only one reasult at the time for all this VAR
VAR Arsenal = {Bad, Medium, Good}
VAR Barcelona = {Bad, Medium, Good}

That report need to have an overall status performance guided by the next values:
Bad = 3
Medium = 2
Good = 1

Where the max value between of them is the overall status

For example:

VAR PSG performance = Bad or 3
VAR Arsenal = Medium or 2
VAR Barcelona = Good or 1

Overall status = Bad because is the highets value 

I hope you can help me with this, in order to not use more than 50 nested if XD

[parry2k · Accepted solution]

@ittahashi you can use following expression in your measure

New Measure = 
VAR PSG = 3 //your psg calculation
VAR ARS = 2 //your arsenol calculation 
VAR BAR = 2 //your barcelona calculation
RETURN
MAXX ( { PSG, ARS, BAR }, [Value] )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.