Power BI doing wrong calculations

Anonymous ,

To ensure the cumulative total is calculated correctly for each month without relying on intermediate or potentially blank values, we can use a SUMX approach. This modified measure iterates over all dates up to and including the current month and adds up the Result values.

Here's the modified measure to accumulate properly:

Cumulative Total = 
VAR CurrentDate = MAX('Calendar'[Date])
RETURN
    SUMX(
        FILTER(
            ALL('Calendar'),
            'Calendar'[Date] <= CurrentDate
        ),
        [Result]
    )

• CurrentDate: This variable captures the current row's date in the context, which acts as the endpoint for our cumulative calculation.
• FILTER(ALL('Calendar'), 'Calendar'[Date] <= CurrentDate): This filter retrieves all rows from the Calendar table up to the current date, removing any filters that might interfere.
• SUMX(..., [Result]): By iterating over each date in the filtered range, this formula sums up all [Result] values up to the CurrentDate, ensuring an accurate cumulative calculation.

Best regards,