Forum Discussion

WWC2024's avatar
WWC2024
Frequent Visitor
1 year ago
Solved

TOTAL ROW IS WRONG

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 a...
Need Help
  • mdaatifraza5556's avatar
    mdaatifraza5556
    1 year ago

    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.

mdaatifraza5556's avatar
mdaatifraza5556
Super User
1 year ago

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's avatar
    WWC2024
    Frequent Visitor
    1 year ago

    Dear friend, 

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

    Thanks for your assist