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
Post a Comment