Forum Discussion

am_i_really's avatar
am_i_really
Frequent Visitor
3 years ago

Switch statement based on another measure

Hi All,    I'm trying to write a measure that will give me a specific value based on the result of another measure. I have the following measure "NON-PM Score = DIVIDE([NON-PM On Time], [NON-PM Tot...
"DAX"
@Power BI
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

am_i_really Hard to say why it isn't working. You could simplify it and get better performance this way. Perhaps provide sample data and a description of what is going wrong.

Measure = 
  VAR __Measure = 'Measures Table'[NON-PM Score]
  SWITCH(
    TRUE(),
    __Measure < .7, "1",
    __Measure > .69 < .80, "2",
    __Measure > .79 < .90, "3",
    __Measure > .89 < .95, "4",
    "5"
  )