Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If Statement based on string value

Hello, Quick need have two measures. Measure A and Measure B. Want to write an if statement that if table[status]="PR" then Measure A else Measure B. Status has only has 3 distinct values in million ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Does this measure work?

    TimelyMeausre=if(max(table[status])="PR",MeasureA, MeasureB)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Try a measure like

TimelyMeausre=sumx(values(table[status]) , if(max(table[status])="PR",[MeasureA],[MeasureB]))

 

check

TimelyMeausre=if(max(table[status])="PR",[MeasureA],[MeasureB])