Using OR conditions between slicers in DAX

 https://www.youtube.com/watch?v=l5JX3G5Ntzk


https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/


Set-Based Solution:

Create table to be used as a filter in CALCULATE:

UNION

  • Crossjoin the selections in the Product[Brand] slicer with any Customer[Occupation]
  • Crossjoin the selections in the Customer[Occupation] slicer with any Product[Brand]

OR #1 :=
CALCULATE (
    [Units],
    UNION (
        CROSSJOIN ( VALUES ( 'Product'[Brand] ), ALL ( Customer[Occupation] ) ),
        CROSSJOIN ( ALL ( 'Product'[Brand] ), VALUES ( Customer[Occupation] ) )
    )
)

Comments

Popular posts from this blog

Difference between DISTINCT and VALUES in DAX