Forum Discussion
Data modeling
Thank you for your help,
it works fine but I need to summarize (first, count,...) one column to display the others columns in the others tables.
Why I should use one summarized column to propogate the filter?
Best Regards!
Hi wael
You can consider to create multiple dimension tables, in your model, you only have one dimension table and multiple fact tables, you may consider to create one more dimension tables bridge tables.
You can refer to the following link.
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
Thinks for replay,
The "Employement contract" serves as a bridge table, the ID column contains all unique value of ID_Contract. Your link refers to many-to-many relationship but the relationship is actually one to many.
The relationship filter propagation works properly from "Employement contract" with one table, but it does not work with severel tables.
If I add a bridge table witch colum should contains this table?
Best Regards!