Forum Discussion
Solved
IF statement not working properly
Hello, I am trying to do an easy if and such as below. Then I want to count how many 1, 2 and 3 I have, and this is not working. It only shows 3. Firts I could not use category=C...
Hi there,
A simple solution would be to use your measure you created but do it as a calculated column instead of a measure. You would set the column as the legend/column 1 and then column 2 of the table you would use the same column except set the column operation = count.
Hope that helps.
Exactly, I am using a flag using the most recent date. I will try your suggestion 🙂 thank you