https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3106796#M109545 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="501589" data-lia-user-login="odada11" class="lia-mention lia-mention-user">odada11</a>&nbsp;</P><DIV><SPAN>try to plot a table bisual with&nbsp;the segment column and a measure like:</SPAN></DIV><DIV><SPAN>Pct =</SPAN></DIV><DIV><SPAN>DIVIDE(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;SUM(TableName[PNT]),<BR /></SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;CALCULATE(</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(TableName[PNT]),&nbsp;</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL(TableName[segment])</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )<BR /></SPAN></DIV><DIV><SPAN>)</SPAN></DIV> Thu, 02 Mar 2023 00:13:28 GMT FreemanZ 2023-03-02T00:13:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3106460#M109516 <P>Hello All,</P><P>pls i have a table</P><P><img /></P><P>How do i calculate the percentage of total for PNT that belongs to each segment. pls help with the Dax</P> Wed, 01 Mar 2023 18:43:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3106460#M109516 odada11 2023-03-01T18:43:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3106796#M109545 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="501589" data-lia-user-login="odada11" class="lia-mention lia-mention-user">odada11</a>&nbsp;</P><DIV><SPAN>try to plot a table bisual with&nbsp;the segment column and a measure like:</SPAN></DIV><DIV><SPAN>Pct =</SPAN></DIV><DIV><SPAN>DIVIDE(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;SUM(TableName[PNT]),<BR /></SPAN></DIV><DIV><SPAN>&nbsp; &nbsp;CALCULATE(</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM(TableName[PNT]),&nbsp;</SPAN></DIV><DIV><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL(TableName[segment])</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )<BR /></SPAN></DIV><DIV><SPAN>)</SPAN></DIV> Thu, 02 Mar 2023 00:13:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3106796#M109545 FreemanZ 2023-03-02T00:13:28Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3108070#M109680 <P>Thank you very much</P> Thu, 02 Mar 2023 14:46:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-TO-CALCULATE-THE-PERCENTAGE-OF-TOTAL/m-p/3108070#M109680 odada11 2023-03-02T14:46:15Z