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! I am building a measure in DAX and running into some problems with the denominator which is made up of the conditional statement below.
(A or B) and not C and D
Using CALCULATE, but wondering if I should be using COUNT or something else.
Solved! Go to Solution.
Try to include FILTER function inside CALCULATE and place your conditions inside. You might need to have multiple FILTER functions if the conditions invlove multiple tables.
Try to include FILTER function inside CALCULATE and place your conditions inside. You might need to have multiple FILTER functions if the conditions invlove multiple tables.
I agree with your recommendation. I was attempting to use FILTER as well so I will explore that and test. Thank you.
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 |
---|---|
43 | |
26 | |
20 | |
14 | |
8 |
User | Count |
---|---|
73 | |
47 | |
45 | |
17 | |
17 |