Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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 row data set. So in theory for my measure.

 

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

 

Any help?

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Does this measure work?

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

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Does this measure work?

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

  • amitchandak's avatar
    amitchandak
    Super User
    5 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])