Forum Discussion
ittahashi
3 years agoFrequent Visitor
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 ...
- 3 years ago
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.
parry2k
3 years agoSuper User
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.