Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Compare two fields by Coexistence and Exclusivity - DAX Approach

Hello,   I have two main fields: - Relative - Child   And I have two separate slicers: - Slicer 1: Select Children A - Slicer 2: Select Children B   I'm looking for 3 DAX expressions to ret...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Solution:

     

    Turns out there's a function called INTERSECT that does exactly what I was looking for.

     

    And for exclusive Children, just take selected values and subtract intersection.