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...
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 👍