Forum Discussion
Solved
Filtering Slicer - Base on another tables Boolean value
Hi, I have 3 imported tables and I am trying to show, and then filter the data joined in a table visual with a slicer. Each table value has unique ID to make relationships easy. Tables: - ...
You have two options here:
Switch the crossfilters to bidirectional, so that the building-table filters the floors and the floors filter the spaces. But be aware of all negative aspects of bidirectional filtering.
The other option ist to denormalize the dimensional tables to one in Power Query, so that you have all dimensional data in one place.
I am a DAX complete newbie but I like use real world examples to learn 😛 Is it possible to have an inactive relationship and write some sort of DAX query to check it?
OR.. perhaps add a custom column in Transform Data?