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

UPDATE

 

I have tried to combine a aggregate function like below 

 

 

 

status = If(ALL('TimeExport (3)'[BudgetClosed]) = "True","Closed","Active")
 
but I got this error 
 
This is most likely because the values in the table are booleans.
any solution would be greatly appreciated!
  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous ,
    Try using MAX instead of ALL.

    • 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