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.

 

 

Hi Sarutra 

What do TRUE and NO TRUE mean? What is your expected result?

Hi,

I created this measure

Measure = if(ISBLANK([Unpaid Amount]),BLANK(),SUMX(VALUES('sales-payments'[Indeksas]),[Unpaid Amount]))

Hope this helps.