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:
Super UserHi Cling -
Create the following relationships:
A → Intermediate (One-to-Many, Bidirectional).
B → Intermediate (One-to-Many, Bidirectional).
B → Other Table (One-to-Many, Single Direction).
Ensure the relationship between A and B is indirect via the intermediate table.
The key is to use bidirectional filtering only where necessary and control propagation using single-direction relationships and DAX measures. If further customization is needed, consider calculation groups for enhanced control. Let me know if any further details required to support on this.