TOTAL ROW IS WRONG

Question

Dear all,&nbsp;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.Would you happen to know the reason for this issue? If possible, could you please help me resolve it?I would really appreciate your insights.Thank you in advance for your time and support!&nbsp;&nbsp;total actual sale adjustment =IF(&nbsp; &nbsp; [total actual sale]&gt;=[total goal], &nbsp; &nbsp; [total goal],&nbsp; &nbsp; [total actual sale])&nbsp;&nbsp;&nbsp;&nbsp;

mdaatifraza5556 · Accepted Answer

Hi&nbsp;WWC2024&nbsp;To Calculate&nbsp;total actual sale adjustment you can use the below DAX.total actual sale adjustment =SUMX (&nbsp; &nbsp; VALUES ( sales[program] ),&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp;[total actual sale] &gt;= [total goal],&nbsp; &nbsp; &nbsp; &nbsp; [total goal],&nbsp; &nbsp; &nbsp; &nbsp; [total actual sale]&nbsp; &nbsp; ))&nbsp;&nbsp;&nbsp;2.&nbsp; &nbsp; To calculate&nbsp;Total Actual Sale Adjustment % use below DAX.&nbsp;Total Actual Sale Adjustment % =DIVIDE(&nbsp; &nbsp; [Total Actual Sale Adjustment],&nbsp; &nbsp; [Total Goal],&nbsp; &nbsp; 0)&nbsp;&nbsp;If this answers your questions, kindly accept it as a solution and give kudos.

Forum Discussion

TOTAL ROW IS WRONG

2 Replies

Related content

Wrong Total

Wrong Total in Table

DAX total != total rows

custom total row

Wrong total