Forum Discussion
Many to Many relationship query
I have table A (Fact table) many to many B many to many C
A table have measure Sum(sales)
I want to filter the A table measure using C table column
Can I do that? if yes it will work?
Let me know if there is a workaround also
1 Reply
Hello Legend_11 ,
well the best way to do is to make the data model as a star schema so you could acheive what you want in a smooth way and better performance.
learn more about star schema 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 👍
