Manage Relationships

[Anonymous]

Hello Folks... I come across a query where I have to build a relation between multiple tables ,the scenario is like , Parent Node : Category Name (Appliances) Child Node : Sub-Category Name (Washing Machines ,Fans,Lights,..etc,) Leaf Node : (Whirpool , LG, Haier ,ETC ) Table-1 Contains Parent Node values (Category as Col-Header Under that category values ) Table-2 Contains Child Node value-1 (as Column name) Table-3 Contains Child Node value-2 (as Column name) Table-4 Contains Child Node value-3 (as Column name) So now I have to relate these tables with a relation of row value of Table-1 relates to column names of Table(2,3,4) Kindly suggest is this approach is optimal and accurate or not ,If so suggest Dax functions or relevant code . Thanks In advance . @amitchandhak @Arul

[Idrissshatila]

Hello @Anonymous ,

use the star-schema model to build the relationship for better performance.

check it here https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin