Forum Discussion
Solved
Date Modelling - Filtering a Dimension by another Dimension without bidirectional filtering
Hi, i am having problems solving the task to build a slicer that filters Dimensions A (Business Units) and simultaneously filtering another Dimension B (Location). So, if I filter the Busines...
You don't need the mapping table. All you need is a measure to use as a filter in both slicers.
In this example, the model is as follows.
The measure to use as a filter is (Ftable is the fact table):
Filter Slicers = COUNTROWS(RELATEDTABLE(FTable))Add the measure to the filters in the filter pane for each slicer and set the value to greater or equal to 1:
and you get:
You don't need the mapping table. All you need is a measure to use as a filter in both slicers.
In this example, the model is as follows.
The measure to use as a filter is (Ftable is the fact table):
Filter Slicers =
COUNTROWS(RELATEDTABLE(FTable))Add the measure to the filters in the filter pane for each slicer and set the value to greater or equal to 1:
and you get: