undefined

[AKR27]

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.

[tamerj1 · Accepted solution]

@AKR27 

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. 

[AKR27]

I agree with your recommendation. I was attempting to use FILTER as well so I will explore that and test. Thank you.