topic Re: TOTAL ROW IS WRONG in Developer https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4665909#M60720 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1253435" data-lia-user-login="WWC2024" class="lia-mention lia-mention-user">WWC2024</a>&nbsp;<BR /><BR />To Calculate&nbsp;<SPAN>total actual sale adjustment you can use the below DAX.<BR /><BR /></SPAN></P><DIV><DIV><SPAN>total actual sale adjustment =</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN> ( </SPAN><SPAN>sales</SPAN><SPAN>[program]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>[total actual sale]</SPAN><SPAN> &gt;= </SPAN><SPAN>[total goal]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[total goal]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[total actual sale]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV><DIV><SPAN>2.&nbsp; &nbsp; To calculate&nbsp;Total Actual Sale Adjustment % use below DAX.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>Total Actual Sale Adjustment % =</SPAN></DIV><DIV><SPAN>D</SPAN><SPAN>IVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; [T</SPAN><SPAN>otal Actual Sale Adjustment],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; [To</SPAN><SPAN>tal Goal],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV></DIV></DIV><P><SPAN>&nbsp;</SPAN></P><P><SPAN><img /></SPAN></P><P>&nbsp;</P><P><SPAN>If this answers your questions, kindly accept it as a solution and give kudos.</SPAN></P> Thu, 24 Apr 2025 04:59:09 GMT mdaatifraza5556 2025-04-24T04:59:09Z TOTAL ROW IS WRONG https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4665853#M60719 <P>Dear all,&nbsp;</P><P><SPAN>I am working on calculating the true sale performance, where the maximum actual sale should not exceed the set goal. However, after implementing the following measurement in Power BI, I am noticing discrepancies—the total numbers and percentages are incorrect.<BR />Would you happen to know the reason for this issue? If possible, could you please help me resolve it?<BR />I would really appreciate your insights.<BR />Thank you in advance for your time and support!&nbsp;</SPAN></P><P>&nbsp;</P><DIV><SPAN>total actual sale adjustment =</SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>[total actual sale]</SPAN><SPAN>&gt;=</SPAN><SPAN>[total goal]</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>[total goal]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>[total actual sale]</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><P>&nbsp;</P><P><img /></P><P><img /></P><DIV><DIV>&nbsp;</DIV></DIV><P>&nbsp;</P><P>&nbsp;</P> Thu, 24 Apr 2025 04:23:20 GMT https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4665853#M60719 WWC2024 2025-04-24T04:23:20Z Re: TOTAL ROW IS WRONG https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4665909#M60720 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1253435" data-lia-user-login="WWC2024" class="lia-mention lia-mention-user">WWC2024</a>&nbsp;<BR /><BR />To Calculate&nbsp;<SPAN>total actual sale adjustment you can use the below DAX.<BR /><BR /></SPAN></P><DIV><DIV><SPAN>total actual sale adjustment =</SPAN></DIV><DIV><SPAN>SUMX</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>VALUES</SPAN><SPAN> ( </SPAN><SPAN>sales</SPAN><SPAN>[program]</SPAN><SPAN> ),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp;</SPAN><SPAN>[total actual sale]</SPAN><SPAN> &gt;= </SPAN><SPAN>[total goal]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[total goal]</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>[total actual sale]</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV><DIV>&nbsp;</DIV><DIV><SPAN>2.&nbsp; &nbsp; To calculate&nbsp;Total Actual Sale Adjustment % use below DAX.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><DIV><SPAN>Total Actual Sale Adjustment % =</SPAN></DIV><DIV><SPAN>D</SPAN><SPAN>IVIDE</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; [T</SPAN><SPAN>otal Actual Sale Adjustment],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; [To</SPAN><SPAN>tal Goal],</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>0</SPAN></DIV><DIV><SPAN>)</SPAN></DIV></DIV></DIV></DIV><P><SPAN>&nbsp;</SPAN></P><P><SPAN><img /></SPAN></P><P>&nbsp;</P><P><SPAN>If this answers your questions, kindly accept it as a solution and give kudos.</SPAN></P> Thu, 24 Apr 2025 04:59:09 GMT https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4665909#M60720 mdaatifraza5556 2025-04-24T04:59:09Z Re: TOTAL ROW IS WRONG https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4667333#M60767 <P>Dear friend,&nbsp;</P><P>I've tested the formula, and it works— Super ! ! !</P><P>Thanks for your assist</P><P>&nbsp;</P> Thu, 24 Apr 2025 17:56:53 GMT https://community.fabric.microsoft.com/t5/Developer/TOTAL-ROW-IS-WRONG/m-p/4667333#M60767 WWC2024 2025-04-24T17:56:53Z