No correspondence between table information

[AlexisPREVOT]

Hello,

I am looking from a customer list to find the selling prices of the corresponding items.

Here are my tables with their relationships to make it easier to understand:

For each PRO_REFCONST - Copy (my first table) corresponds an ELC_MNTHT (last table) and this for each CLIENT ID.

The concern I have is that when I create my visual I don't get the correct amounts in front of each row.

Would you have an idea please ?

thank you by advance,

Alexis

[Anonymous]

Hi  @AlexisPREVOT ,

You can convert your data model into a star model or a snowflake model.

Star schema

Star Schema vs Snowflake Schema

https://debbiesmspowerbiazureblog.home.blog/2020/06/17/power-bi-models-snowflake-to-star-schema/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisPREVOT]

Hi @Anonymous and @lbendlin ,

Thank you for your answers.

I'm going to try to do the star schema but I feel like I only have fact tables so I'm going to have to try transforming them to make it work.

Thank you again for your help

[lbendlin · Accepted solution]

That's not a data model - they usually expect dimension tables and fact tables with 1:* relationships, ideally resulting in a snowflake layout.  If you have multiple fact tables then they should be controlled via dimensions, and not by each other.

Can you decide which of your tables are dimensions and which are facts?