Forum Discussion
Modelling Problem
Hi Cling ,
Here I create a sample to have a test. I think by default the direction for one to many relationship is single.
I suggest you to keep single instead of choose both between A and INTERMEDIATE / B and INTERMEDIATE.
In my sample the table based on [DESC_A] and [DESC_B] is the same as yours.
Data model:
Then if I click the data which only from Table A or Table INTERMEDIATE, the data from other table won't be filtered.
However if I click the table contains data from Table B, it will be filtered. This is because that [DESC_B] from B table could interact data from other table.
I suggest you to turn off the interaction in visuals which you don't want it be impacted by others.
For reference: Change how visuals interact in a report - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Doing what you indicate, if you filter on A, the filter would propagate to B through the intermediate table and affect the other tables:
Hi Cling ,
Here I create a sample to have a test. I think by default the direction for one to many relationship is single.
I suggest you to keep single instead of choose both between A and INTERMEDIATE / B and INTERMEDIATE.
In my sample the table based on [DESC_A] and [DESC_B] is the same as yours.
Data model:
Then if I click the data which only from Table A or Table INTERMEDIATE, the data from other table won't be filtered.
However if I click the table contains data from Table B, it will be filtered. This is because that [DESC_B] from B table could interact data from other table.
I suggest you to turn off the interaction in visuals which you don't want it be impacted by others.
For reference: Change how visuals interact in a report - Power BI | Microsoft Learn
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.