Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
13 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |