Forum Discussion
Total Not Adding
Hi Anonymous ,
It's a common issue.
Here're some blogs about fixing the wrong total using measures. Please refer to
Fixing Incorrect Totals Using DAX Measures In Power BI – Master Data Skills + AI (enterprisedna.co)
Why my measure returns the wrong total? How to fix that? (vahiddm.com)
Why Power BI totals might seem inaccurate - SQLBI
Dealing with Measure Totals - Microsoft Fabric Community
To update these measures to have the sum of the visible values in the visual, we need to use the IF statement with HASONEVALUE, SUMMARIZE, and SUMX.
HASONEVALUE: Returns TRUE when the context for columnName has been filtered down to one distinct value only. Otherwise is FALSE.
SUMMARIZE: Returns a summary table for the requested totals over a set of groups.SUMX: Returns the sum of an expression evaluated for each row in a table.
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.
Hi Anonymous ,
It's a common issue.
Here're some blogs about fixing the wrong total using measures. Please refer to
Fixing Incorrect Totals Using DAX Measures In Power BI – Master Data Skills + AI (enterprisedna.co)
Why my measure returns the wrong total? How to fix that? (vahiddm.com)
Why Power BI totals might seem inaccurate - SQLBI
Dealing with Measure Totals - Microsoft Fabric Community
To update these measures to have the sum of the visible values in the visual, we need to use the IF statement with HASONEVALUE, SUMMARIZE, and SUMX.
HASONEVALUE: Returns TRUE when the context for columnName has been filtered down to one distinct value only. Otherwise is FALSE.
SUMMARIZE: Returns a summary table for the requested totals over a set of groups.
SUMX: Returns the sum of an expression evaluated for each row in a table.
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.