Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Have situation when getting wrong sum. It calculates wrong total sum, how fix it?
Here is a example:
Solved! Go to 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.
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.