Many to Many relationship query

[Legend_11]

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

[Idrissshatila]

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 👍

Follow me on Linkedin