https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/creating-a-measure-to-multiply-two-columns-from-two-different/m-p/2984881#M100132 <P>Hi All,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>I have a strict condition of using a measure only and not a calculated column.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 22 Dec 2022 17:11:48 GMT Anoushka_pbi 2022-12-22T17:11:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/creating-a-measure-to-multiply-two-columns-from-two-different/m-p/2984881#M100132 <P>Hi All,</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>I have a strict condition of using a measure only and not a calculated column.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 22 Dec 2022 17:11:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/creating-a-measure-to-multiply-two-columns-from-two-different/m-p/2984881#M100132 Anoushka_pbi 2022-12-22T17:11:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/creating-a-measure-to-multiply-two-columns-from-two-different/m-p/2985114#M100145 <P>&nbsp;Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="490381" data-lia-user-login="Anoushka_pbi" class="lia-mention lia-mention-user">Anoushka_pbi</a>&nbsp;,</P><P>&nbsp;You may want to create a bridge table to avoid the many to many relationship. Here is some additional information:</P><P>&nbsp;</P><P><A href="https://www.phdata.io/blog/how-to-create-a-bridge-table-in-power-bi/#:~:text=Bridge%20Table%20Use%20Cases,even%20in%20multiple%20dimension%20tables" target="_blank">https://www.phdata.io/blog/how-to-create-a-bridge-table-in-power-bi/#:~:text=Bridge%20Table%20Use%20Cases,even%20in%20multiple%20dimension%20tables</A>.</P><P>&nbsp;</P><P><A href="https://www.seerinteractive.com/insights/join-many-many-power-bi" target="_blank">https://www.seerinteractive.com/insights/join-many-many-power-bi</A></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 22 Dec 2022 19:45:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/creating-a-measure-to-multiply-two-columns-from-two-different/m-p/2985114#M100145 djurecic 2022-12-22T19:45:36Z