Forum Discussion

williamy281's avatar
williamy281
Frequent Visitor
2 years ago
Solved

DAX Formula to Filter same values across 2 columns

Hello,

 

   Need to try get a DAX formula that filter conditions on the same values across 2 columns.

So, this my current data with this formula - 

Numerator = CALCULATE(Sum(Race_Ethnicity_Performance_DataSet[Count]), FILTER(Race_Ethnicity_Performance_DataSet, NOT Race_Ethnicity_Performance_DataSet[Value1] in {"UNK","ASKU"} && Race_Ethnicity_Performance_DataSet[Value2] in {"UNK","ASKU"}))

 

RaceEthnicityNumeratorTotal
Ask But No Answer Asked But No Answer 17,719
 Hispanic or Latino  662
 Not Hispanic or Latino  466
 Unknown 2,757

  

What I need in the Resulting Table is the Following:

RaceEthnicityNumeratorTotal
Ask But No Answer Asked But No Answer 17,719
 Hispanic or Latino662 
 Not Hispanic or Latino466 
 Unknown 2,757

 

Is there a solution to this ?  Isn't my Dax formula Correct ?

Thanks.

 

  • williamy281's avatar
    williamy281
    2 years ago

    Never mind.  I figured it out. Used or in the formula with different values.

2 Replies

  • williamy281's avatar
    williamy281
    Frequent Visitor
    2 years ago

    Never mind.  I figured it out. Used or in the formula with different values.

    • VahidDM's avatar
      VahidDM
      Icon for Super User rankSuper User
      2 years ago

      So make sure to close this, or mark your reply as a solution.