TOTAL ROW IS WRONG

[WWC2024]

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]

)

[mdaatifraza5556 · Accepted solution]

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],

    0

)

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

[WWC2024]

Dear friend, 

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

Thanks for your assist