Forum Discussion
Table Relationship
Hello, I'm new to PowerBI and have some problem with table relationship. The table relationship concept in PowerBI seems different with the one in common DBMS. Suppose I have these simple tables: ...
This is a good example of how the snowflake schema differs from the star schema. In a common DBMS, a snowflake schema is used. But in data analytics, a star schema is a better choice. The approach I would take is to add branchname to tables Customer and SalesPerson (and remove branchid from these two tables). You can then remove the Branch table. The tables Customer and SalesPerson have a 1:* relationship with Transaction, enabling you to filter using any of the fields in Customer and SalesPerson (including branchname).