I noticed that using the "Select All" button is different from selecting every item in the filter manually.
Consider the case of two tables, Dim and Fact. They are related on Key, and Dim filters Fact.
Fact
Key Value
1 10
2 12
2 14
Dim
Key Attribute
1 Red
2 Blue
3 Green
I visualize data from Fact, while using the Attribute column in Dim in a Slicer. The problem is that there are Attributes in the slicer that don't exist in the Fact table, and with a large Fact and Dim table, the slicer can be unnecessarily big.
My first solution was to change the filter direction to both ways. Then I add the Key column from the Fact table into the filters pane. If I press "select all", the Fact table seem to not filter the Dim table, but if I remove "select all" and manually click on all keys that exist in the Fact table, the Dim table is filtered such that only the Attributes from Dim that exist in Fact will show in the slicer.
This is unfeasable for larger tables, and my solution was to add a new column in the Dim table
LinesWithData =
IF(
'Dim'[Key] in DISTINCT('Fact'[Key]),
TRUE(),
FALSE()
)
And use it in the filters pane and select True.
Does anyone have a different solution to this, considering adding new column might not be possible when connecting to some data sources?
In my opinion, it would be best if selecting all using the button and selecting all manually yield the same result, filtering the related tables. Note that I have a working solution to my problem, but I want a discussion because this interaction seem illogical to me.
Thanks,
benyhh
