Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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).
Solved! Go to Solution.
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
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
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |