topic Re: Average per row for each resource and sum for the total in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116846#M163433 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="742455" data-lia-user-login="mimingiang" class="lia-mention lia-mention-user">mimingiang</a>&nbsp;</P> <P>I believe this is your expected result&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>Please find the PBIX file&nbsp;</P> <P>&nbsp;</P> <P>Need a Power BI Consultation? Hire me on <A href="https://bit.ly/4d3oy4s" target="_blank" rel="noopener">Upwork</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Connect on <A href="https://www.linkedin.com/in/tharun-kumar-ravikrindhi/" target="_blank" rel="noopener">LinkedIn</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <DIV class=""><BR /><BR /> <DIV class=""><BR /><BR /> <DIV style="border-radius: 1px; padding: 10px; border: solid #cccccc 1px; background: #fafafa no-repeat right 10px center;"><BR /> <TABLE> <TBODY> <TR> <TD><BR /><BR /> <TABLE> <TBODY> <TR> <TD><STRONG style="margin-right: 3px;"><STRONG style="margin-right: 3px;">Did I answer your question? Mark my post as a solution!</STRONG></STRONG></TD> </TR> <TR> <TD><STRONG style="margin-right: 3px;"><STRONG style="margin-right: 3px;">If I helped you, click on the Thumbs Up to give Kudos.<BR /></STRONG></STRONG><BR /> <P style="padding: 0; margin: 5px 50px 0 0;">Proud to be a Super User!</P> </TD> <TD><BR /> <DIV><img /></DIV> </TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> <P>&nbsp;</P> Sat, 24 Aug 2024 13:43:54 GMT tharunkumarRTK 2024-08-24T13:43:54Z Average per row for each resource and sum for the total https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116802#M163431 <P>Hi I have the first table&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Order number</TD><TD>Sales person</TD></TR><TR><TD>1</TD><TD>A</TD></TR><TR><TD>1</TD><TD>B</TD></TR><TR><TD>2</TD><TD>C</TD></TR><TR><TD>3</TD><TD>D</TD></TR></TBODY></TABLE><P><BR />I have another table where I can calculate the sum value of the order. I would like to show on matrix levels.&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Order number</TD><TD>Amount</TD></TR><TR><TD>1</TD><TD>200</TD></TR><TR><TD>2</TD><TD>300</TD></TR><TR><TD>3</TD><TD>400</TD></TR></TBODY></TABLE><P><BR />I want to get this matrix the amount on sales order amount = sum(amount)/distincount of sales person.&nbsp;<BR /><BR /></P><P><img /></P><P>&nbsp;</P> Sat, 24 Aug 2024 11:38:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116802#M163431 mimingiang 2024-08-24T11:38:28Z Re: Average per row for each resource and sum for the total https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116838#M163432 <P>You may want to add a Sales Person Dimension table to your data model.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Then you can use your preferred DAX to calculate the mapping.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Sat, 24 Aug 2024 13:50:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116838#M163432 lbendlin 2024-08-24T13:50:06Z Re: Average per row for each resource and sum for the total https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116846#M163433 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="742455" data-lia-user-login="mimingiang" class="lia-mention lia-mention-user">mimingiang</a>&nbsp;</P> <P>I believe this is your expected result&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>Please find the PBIX file&nbsp;</P> <P>&nbsp;</P> <P>Need a Power BI Consultation? Hire me on <A href="https://bit.ly/4d3oy4s" target="_blank" rel="noopener">Upwork</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Connect on <A href="https://www.linkedin.com/in/tharun-kumar-ravikrindhi/" target="_blank" rel="noopener">LinkedIn</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <DIV class=""><BR /><BR /> <DIV class=""><BR /><BR /> <DIV style="border-radius: 1px; padding: 10px; border: solid #cccccc 1px; background: #fafafa no-repeat right 10px center;"><BR /> <TABLE> <TBODY> <TR> <TD><BR /><BR /> <TABLE> <TBODY> <TR> <TD><STRONG style="margin-right: 3px;"><STRONG style="margin-right: 3px;">Did I answer your question? Mark my post as a solution!</STRONG></STRONG></TD> </TR> <TR> <TD><STRONG style="margin-right: 3px;"><STRONG style="margin-right: 3px;">If I helped you, click on the Thumbs Up to give Kudos.<BR /></STRONG></STRONG><BR /> <P style="padding: 0; margin: 5px 50px 0 0;">Proud to be a Super User!</P> </TD> <TD><BR /> <DIV><img /></DIV> </TD> </TR> </TBODY> </TABLE> </TD> </TR> </TBODY> </TABLE> </DIV> </DIV> </DIV> <P>&nbsp;</P> Sat, 24 Aug 2024 13:43:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116846#M163433 tharunkumarRTK 2024-08-24T13:43:54Z Re: Average per row for each resource and sum for the total https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116933#M163440 <P>Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="685422" data-lia-user-login="tharunkumarRTK" class="lia-mention lia-mention-user">tharunkumarRTK</a>&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="685422" data-lia-user-login="tharunkumarRTK" class="lia-mention lia-mention-user">tharunkumarRTK</a>. Just want to add some more details for the calculation</P><P>I have another table where I can calculate the sum value of the order. I would like to show on matrix levels.&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Order number</TD><TD>Amount</TD></TR><TR><TD>1</TD><TD>200</TD></TR><TR><TD>2</TD><TD>300</TD></TR><TR><TD>1</TD><TD>400</TD></TR></TBODY></TABLE><P>I have many to many relationship between Orders and Sales Persons</P><TABLE border="1"><TBODY><TR><TD>Order number</TD><TD>Sales person</TD></TR><TR><TD>1</TD><TD>A</TD></TR><TR><TD>1</TD><TD>B</TD></TR><TR><TD>2</TD><TD>B</TD></TR><TR><TD>3</TD><TD>D</TD></TR></TBODY></TABLE><P>I want the end result look like this&nbsp;<BR /><BR /><img /></P> Sat, 24 Aug 2024 18:11:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116933#M163440 mimingiang 2024-08-24T18:11:50Z Re: Average per row for each resource and sum for the total https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116942#M163441 <LI-CODE lang="markup">I have many to many relationship between Orders and Sales Persons</LI-CODE> <P>Don't do that. Use a proper data model.</P> Sat, 24 Aug 2024 18:54:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-per-row-for-each-resource-and-sum-for-the-total/m-p/4116942#M163441 lbendlin 2024-08-24T18:54:03Z