Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 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
Nathaniel_C
6 years agoCommunity Champion
If(table[IsClosed] = "True","Closed","Active")Hi Anonymous ,
Try this.
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
6 years agoNot applicable
Hey there Nathaniel,
It keeps giving me a error as I cant select the table[IsClosed]. This is probably because I need a aggregate function? This is what I get
Let me know what you suggest.