Forum Discussion
Data modeling
Hello everyone and Happy New Year,
I'm trying to find a solution to model my data which look like a star model but my dimension table is in the center and the relationships are in the wrong direction
When I try to create a table with the informations of a contract from differents tables, I get an error "can't display the visual". To solve this problem, I have to use both relationships, but this is not recommended.
What is the best way to model this case
Thank you
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!
4 Replies
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!
Hi wael
If you only have the current bridge table, and you want to filter other tables from this table, you can only consider changing the filter direction to both, because based on your description, if you want to filter tables on the current model, you can only change the filter direction to both.
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.
