Wrong Total sum

Hi Sarutra ,

The "wrong total" issue in Power BI measures is really common and usually happens because DAX calculates the total differently than the individual rows. Here’s how I’d tackle it:

Use SUMX over VALUES: This ensures your custom calculation runs at the row level for each unique Invoice (or whatever your key field is), and then adds everything up for the total. For example:

Unpaid Amount = 
SUMX(
    VALUES('sales payments'[Invoice NR]),
    [Open Order Total] - [Payments]
)

Add HASONEVALUE logic if needed: If your calculation needs to handle both single rows and totals differently, you can use HASONEVALUE to switch logic, like this:

Unpaid Amount = 
IF(
    HASONEVALUE('sales payments'[Invoice NR]),
    [Open Order Total] - [Payments],
    SUMX(
        VALUES('sales payments'[Invoice NR]),
        [Open Order Total] - [Payments]
    )
)

Make sure your tables are joined correctly, and there aren’t any inactive relationships that could mess up the totals. Sometimes creating a quick table with SUMMARIZE or looking at a table visual can help spot why the totals are off. If it’s still not working, feel free to share a sample PBIX file with dummy data. Sometimes it’s something small that’s easy to spot with a real example.