Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
First ever post.
I'm struggling to get the right formula for my solution.
I have a calculated column which follows the logic:
Products bought =
IF( A = 0 && B = 1, 1, 0)
I get the correct output:
Product A 1
Product B 2
Product C 1
Client is asking if the product appears just once, show it as 1, not a 2, so it would be like
Product A 1
Product B 1
Product C 1
Since it's a calculated column, i tried to use this formula for a solution:
IF(SUMX('Table','Table'[Products Bought]) >= 1, 1, 0)
Now I get the proper counts, but I can't get to show the result as a GRAND total or SUB Total.
How do I fix this?
Does my logic make sense?
Thank you in advance DAX guru's!
Solved! Go to Solution.
Hi @Runicas
Maybe you can try:
SUMX(VALUES('Table'[Product]),[Measure])
Where [Measure]=IF(SUMX('Table','Table'[Products Bought]) >= 1, 1, 0)
Hi @Runicas
Maybe you can try:
SUMX(VALUES('Table'[Product]),[Measure])
Where [Measure]=IF(SUMX('Table','Table'[Products Bought]) >= 1, 1, 0)
Thank you very much! Worked like a charm 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
45 | |
15 | |
12 |