Forum Discussion
Filtering two unconnected tables
Ok, first of all delete the relationships between the tables and the RisksControls table. Now join the Area table to both tables in a 1:N relationship single direction with the corresponding fields in the tables. (I have also created a dimension table for year)
The relevant model should look like this:
Nest create a slicer with the field from Area table, create visuals with the fields of both the fact tables and you should get this:
I've attached the smple PBIX file
you should be able to use the Risks Controls table to filter both tables if the values correlate (ie they are not a simple list of values unrelated to each other.
Can you show a depiction of the actual tables in the model view?
Also please show a depiction of the expected outcome and provide sample data or a PBIX file
Good morning,
The input would be:
The outcome should be the following tables with no filter applied:
If the filter Area = A, the outcome should be:
The filter would be in a dropdown list that depends on the Area table.
Thank you so much PaulDBrown !
Ok, first of all delete the relationships between the tables and the RisksControls table. Now join the Area table to both tables in a 1:N relationship single direction with the corresponding fields in the tables. (I have also created a dimension table for year)
The relevant model should look like this:
Nest create a slicer with the field from Area table, create visuals with the fields of both the fact tables and you should get this:
I've attached the smple PBIX file