Forum Discussion

AKR27's avatar
AKR27
New Member
4 years ago
Solved

undefined

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's avatar
    tamerj1
    4 years ago

    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. 

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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's avatar
      AKR27
      New Member
      4 years ago

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