How to fix that sum will be shown correctly in Power BI?

[Analitika]

Hi,

Have situation when getting wrong sum. It calculates wrong total sum, how fix it?

Here is a example:

[v-binbinyu-msft · Accepted solution]

Hi @Analitika ,

This is due to the different reasons of the context, please try below dax formula:

Measure =
SUMX ( VALUES ( Table[column name] ), [measure name] )

 For more details, you can read related document: Dealing with Measure Totals - Microsoft Power BI Community, Why Power BI totals might seem inaccurate - SQLBI

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.