Forum Discussion
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=Cons because I am using direct query so I created a category code (Cons is category code 3).
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.
4 Replies
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.
Hi Jarom,
Thank you for the help. The problem is that I have a table with all orders and I only want to categorize (1,2,3) according the most recent price. In this case I would be evaluating the same PN on different prices...
Is the current price it's own column so for every Row of a PN the current price is shown? Or are you using a date or some flag to identify which record is the current price? If the latter then you can do as I mentioned before and just add a filter to the visual for "current" eq 1
Exactly, I am using a flag using the most recent date. I will try your suggestion 🙂 thank you
