Forum Discussion
Multiple validations on multiple measures.
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
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.
1 Reply
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.