Forum Discussion

ittahashi's avatar
ittahashi
Frequent Visitor
3 years ago
Solved

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 ...
  • parry2k's avatar
    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.