ALLexcept help to calculate correct total

DAX DAX Calculations
2

Hello @farmboy,

Thank You for posting your query onto the Forum.

Well for actuals you already have a correct total i.e. 955 but still just write a simple measure rather than using naked column from the table and to achieve the correct totals of forecast i.e. 900. Just write one small measure to fix it. Below are the measures provided for the reference -

actuals = SUM( ACTUAL[actual] )

fcst totals = 
SUMX(
    SUMMARIZE(
        FarmDetails , 
        FarmDetails[Company] , 
        "@Totals" , 
        [fcst] ) , 
    [@Totals]
)

Also one of our expert @Greg had also created a post pertaining to the topic about “How To Fix Incorrect Totals”. I’m providing a link below of that which contains all the posts that were created by the members so far pertaining to this very similar topic and also contains all the links of the videos as well.

I’m also attaching the working of the PBIX file for the reference as well.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

power bi.pbix (99.2 KB)