Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure with If statement checking for value

Hey everyone,   In my dataset I have a column called "Isclosed" which has a value of True or False.   In my vizualisation I am trying to create a "card" or anything that display "Closed" if the v...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,
    Here is a picture with either a table or a card.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hey Nathaniel_C  i appreciate the help,

 

I am still getting this error when using MAX 

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi Anonymous ,


I will send you a pbix that has this implemented.

 

Status = IF(MAX( mytable[BudgetClosed]) = "True","Closed","Active")

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous ,
    Here is a picture with either a table or a card.
    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
    Nathaniel

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey Nathaniel_C thanks for the help! I had to first convert the whole column to a text type (as it was boolean) so it did not work before but now it works perfectly.