DAX total != total rows

Hi SaaM,

I hope you are doing well today 🙂❤️

There are two solutions you can use to fix the totals issue in your table visual.

Both ensure the total equals the sum of the row values:

Solution 1: Using SUMX with IF

Calcul_incremental :=
SUMX (
    VALUES ( YourTable[YourRowColumn] ),
    VAR Diff = SUM ( YourTable[CA N] ) - SUM ( YourTable[CA N-1] )                  
    RETURN
        IF ( Diff > 0, Diff, 0 )
)

• Evaluates row by row
• Applies the condition per row
• Totals now match the sum of rows

Solution 2: Using SUMX with MAX (shorter)

Calcul_incremental :=
SUMX (
VALUES ( YourTable[YourRowColumn] ),
MAX ( SUM ( YourTable[CA N] ) - SUM ( YourTable[CA N-1] ), 0 )
)                          

• Shorter, cleaner syntax
• Works exactly the same
• Ensures totals equal the sum of rows

Work Notes:

• Replace YourTable[YourRowColumn] with the column that defines each row in your table
• e.g., Customer, Account, Product
• Both approaches work for table, matrix, and card visuals

If this answer helped, kindly give Kudos and mark it as the Accepted Solution

to help other members find it more quickly.

Best regards,

Vaibhav Mahajan

LinkedIn: https://www.linkedin.com/in/vaibhavnmahajan

I'm glad you found a solution! We're here in the community to support each other.

Regards,
Rufyda Rahma | MIE

Hi SaaM,

• For each row:
  Calcul_incremental = IF(diff_CA > 0, diff_CA, 0)
  works correctly because diff_CA is evaluated per row.
• For the total:
  The same formula runs in the grand total context, where diff_CA is aggregated across all rows first. If the combined diff_CA is negative, the condition fails, and the total shows a smaller value.

Please, try something like this:

Calcul_incremental =
SUMX(
    VALUES('YourTable'[YourGroupingColumn]),
    IF([diff_CA] > 0, [diff_CA], 0)
)

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.