Total Not Adding

[WaisaleBunoa]

I am trying to add the Column Target MRC to show total like MRC vs Target. These are measures.

 

[Anonymous · Accepted solution]

Hi @WaisaleBunoa ,

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.

[Ritaf1983]

Hi @WaisaleBunoa 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly