How To Easily Fix Incorrect Measure Totals In Power BI

You might encounter issues with Measures in Power BI Table visualizations with a Total row. The usual complaint is that the "Total" row is “incorrect” for the measure. Usually, the total row is correct for the measure, it's just not what most people expect. In this video, Greg is going to take us through this common problem with Measure Totals and how to solve it.

***** Video Details *****
00:00 Introduction
00:51 Dump filters measure
01:50 Tooltip page
03:03 Incorrect total
06:27 Correct total

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #MeasureTotal

[JessicaLai-bf]

spent about a day trying to figure this one out and this video FINALLY helped me. thanks for not over complicating it to the point of not being able to follow your video instructions. Cheers!

[dana_padrino]

I have always been confused by some of my "Totals" not adding up. This explains it pretty well. Thanks.

[sudarsana]

after spending 3 hours really found the answer here. Thanks you So much!!

[texmexdragon]

Greg...absolutely agree. MICROSOFT ARE YOU LISTENING??

[AshAsmodeus]

these vids are really helping me with the "underwater" behaviour Power-BI tends to enact; thanks a lot :)

[DeronHuskey]

Simple, to-the-point example. Thanks.

[luisbarria]

Thank u so much, i had 3 days with this issue. TSUNAMI OF SUCCESS 4 u bro!

[markdoucette]

Thanks for a very simple solution. Your explanation was very easy to follow. Great job! Thanks.

[joefromdc]

Thanks for the video, how did you get the [__value] at the end of the summarize? I am lost on that part

[naveens]

thanks a lot for this explanation 🙂i was able to fix some issues.

[jujufina]

what if we have both category and subcategory? Should we apply the subcategory measure or the category one? Or there should be a third separate one following other approach?

[cjhoffmn]

This video was very helpful! Can you contrast the solution using the summarize technique here, with a solution I’ve adopted recently which is a
hasonevalue,
switch, true,
[separate measure for each aggregation]
pattern

[GregKramerTenaciousData]

agree. barrier to adoption. hard to get folks excited about something wen the 1st thing they try throws off a wtf experience

[prodone]

I am creating a table based on two columns. both columns are text. one column is "states" the other is "stores" audited within a specific time period. need help!

[nominini]

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The field 'dimensions' of the record wasn't found..
The current operation was cancelled because another operation in the transaction failed.

'.Can anyone help me out in this error to fix this error ?

[lionels]

Hello
How to fix incorrect average on the total lines?

[MarkAzali]

This is working, but now my datagrid seems to load much slower?

[theraveshow]

If you put - 10 within the SUMX formula, like this: Measure Totals = SUMX('Table, [Value] - 10) the whole problem goes away. If the calculation is meant to be on per-row basis, do not put it on aggregation level. That is why it's important to know the concepts behind the calculations, not just blindly puting numbers in without context

[etherlords]

My company is going back to Tableau because of this stupidity. I joined as PBI Dev and I'm getting out of PBI as well. Since the beginning this tool is very problematic in terms of development and analytics.

[CortanHarr]

2 years later and its still not fixed.