creating a measure to multiply two columns from two different tables

[Anoushka_pbi]

Hi All,

Can someone please tell me how I can create a measure that multiplies two columns from two different tables which have a many to many relationship.

In Matrix view i am able to get correct answers for each of the cells but the subtotal is coming out to be wrong for both row and column level.

I have a strict condition of using a measure only and not a calculated column.

[djurecicK2]

 Hi @Anoushka_pbi ,

 You may want to create a bridge table to avoid the many to many relationship. Here is some additional information:

https://www.phdata.io/blog/how-to-create-a-bridge-table-in-power-bi/#:~:text=Bridge%20Table%20Use%20....

https://www.seerinteractive.com/insights/join-many-many-power-bi