DAX Formula to Filter same values across 2 columns

[williamy281]

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"}))

Race	Ethnicity	Numerator	Total
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:

Race	Ethnicity	Numerator	Total
Ask But No Answer	Asked But No Answer		17,719
	Hispanic or Latino	662
	Not Hispanic or Latino	466
	Unknown		2,757

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

Thanks.

[williamy281 · Accepted solution]

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

[VahidDM]

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