Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 -
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.
Solved! Go to Solution.
Never mind. I figured it out. Used or in the formula with different values.
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.