Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
williamy281
Frequent Visitor

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.

 

1 ACCEPTED SOLUTION
williamy281
Frequent Visitor

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

View solution in original post

2 REPLIES 2
williamy281
Frequent Visitor

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

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

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.