Data modeling

[wael]

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

[v-xinruzhu-msft]

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

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many#relate-many-to-many-d...

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.

[wael]

Hi @v-xinruzhu-msft,

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!

[v-xinruzhu-msft]

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.

[wael · Accepted solution]

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!