Total value not correct in visual

[anettpb]

Dear Community!

I would have a problem with my total values in a visual:

The correct value would be in the last column: 120 60 979, and the tpye would be currency. 

A couple of days ago it worked well with this solution, maybe it was an accident...

With Sum, or only using the default total value, the situation is even worse.

'Invoiced_NET',Invoiced_NET[Net-net ár /zsák ] coming from a table, the value is set as Do not summarize, type is whole number

On delivery zsák is a measure, type is whole number, and it is a substraction of values from a table and a measure.

What am I doing wrong?

Thanks a lot if anyone can help!

[v-stephen-msft]

Hi @anettpb ,

It's a common issue. We often use SUMMARIZE function to fix.

Please refer to

Why Your Total Is Incorrect - A Key Power BI Advanced Concept (enterprisedna.co)

Fixing Incorrect Totals Using DAX Measures In Power BI | Enterprise DNA

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[anettpb · Accepted solution]

Hi @v-stephen-msft 

Thank you for the help.

In the meantime I could solve the problem with using Sumx and Value in the function.