topic Re: TOTAL ROW IS WRONG in Developer

TOTAL ROW IS WRONG

WWC2024 — Thu, 24 Apr 2025 04:23:20 GMT

Dear all,

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!

total actual sale adjustment =

IF(

[total actual sale]>=[total goal],

[total goal],

[total actual sale]

)

Re: TOTAL ROW IS WRONG

mdaatifraza5556 — Thu, 24 Apr 2025 04:59:09 GMT

Hi @WWC2024

To Calculate total actual sale adjustment you can use the below DAX.

total actual sale adjustment =

SUMX (

VALUES ( sales[program] ),

IF (

[total actual sale] >= [total goal],

[total goal],

[total actual sale]

)

2. To calculate Total Actual Sale Adjustment % use below DAX.

Total Actual Sale Adjustment % =

DIVIDE(

[Total Actual Sale Adjustment],

[Total Goal],

)

If this answers your questions, kindly accept it as a solution and give kudos.

Re: TOTAL ROW IS WRONG

WWC2024 — Thu, 24 Apr 2025 17:56:53 GMT

Dear friend,

I've tested the formula, and it works— Super ! ! !

Thanks for your assist