Fix Incorrect Totals

[Greg]

Related Content:

Below are a few examples of issues related to the Fix Incorrect Totals DAX Pattern from the eDNA resources.

Enterprise DNA Courses:

Fixing Complex Total Errors - DAX Formula Concepts

Calculate The Total Of Average Results In Power BI Using DAX

How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Enterprise DNA Forum (Search):

Summarize with filtered measure

@nainiu440, Definitely never seen that error before, but looks likes @BrianJ solution works. Also, might want to be careful adding calculated columns in the summarized function. Usually not a problem but when you mix together a filter and the row context in one function it can lead to some interesting results and could be a potential performance hit. I’d use AddColumns and then summarized ADDCOLUMNS( SUMMARIZE( ‘Regions Table’, ‘Regions Table’[City] ), “Total Sales”,…

Totals Not Coming Correct Virtual Table

@AntrikshSharma, Always good to see how others come up with solutions. I took a look at yours and have a few notes (if you dont mind ) When you FILTER over a SUMMARIZE table it results in the Storage Engine (i.e. the fast one) not being able to complete that task and has to get some help from the Formula Engine, resulting in CallbackID, which degrades performance. When we run in Dax Studio, we can see that happening. [image] Crossjoin doesnt suffer from that issue, but doing …

https://forum.enterprisedna.co/t/fixing-complex-total-errors-dax-formula-concepts/598

Grand total of branch measure

Interestingly this works in your model Credit Capacity SUMMARIZE = SUMX( SUMMARIZE( Counterparties, Counterparties[CounterpartyName], "CollCap", [Collateral Capacity], "LimCap", [Limit Capacity] ), MIN( [CollCap], [LimCap] ) ) So it has to do with something with the table within the SUMMARIZE function. It was reading it correctly when it was just VALUES. It’s quite intriguing. I’m working through it to understand it much better.

Visual Total not the Grand Total I'm expecting

That makes sense. In order to get the total you want you need to change the filter context. So for each row (month and year in this case) the filter context is just that month and year and then you get a distinct count of patients in that specific month and year. When you look at the grand total it is taking all of the month and years and giving you the distinct count of patients using that context. Which is why you see 1355 since a patient can only be counted once in that context. So what we…

https://forum.enterprisedna.co/t/fixing-errors-with-your-totals-efficiently/4948

Enterprise DNA Forum (EDNA):

Incorrect total in Power BI

@Chukliz, The incorrect totals problem is a very common one in Power BI. Please check out the thread below, which includes two videos from @sam.mckay explaining how to fix this problem: If you still have problems after taking a look, please just post your PBIX file and we can work through the specific solution for your data. I hope this is helpful. Brian P.S. here’s another thread that provides more explanation as to why the incorrect total/subtotal problem occurs, with an additional u…

Incorrect column totals in final results

@BenBen2, Two solutions for the price of one today… Solution 1 This is the way I’ve always done it in the past. Basic construct is to: Within a variable, use virtual table functions like SUMMARIZE or SELECTCOLUMNS to create the necessary evaluation contexts for your calculation Wrap that table in ADDCOLUMNS function to add a column for the measure you want to sum correctly In the RETURN statement of the measure, test whether the current row is a a total row or not (typically using HASONE…

DAX Measure Total Incorrect

@james8992, Please check out the link below, with a solution to a very similar problem and two highly relevant video links: If you still need help after that, please post your PBIX file and I’ll be glad to work through it with you. Brian

Pareto Rule Total Issue

Hi, I watched Pareto Rule, there are no resources but is the total correct for 20 %? [image] If we would add every individual customer for each state the total doesn’t add up to 10k is way over.

Pareto / TOPN/ Tree Map issue

Hello @Matty, My sincere apologies. Actually I thought in your file “Customer Ranking” was calculated based on Sales Table so in my formula also I by mistake referenced it as “Sales” instead of “Customers” and due to referencing error on my part the individual line items total showed correctly but the “Grand Total” received an error. Below are the changed formula for the reference - Part 1 : Calculation of 20% Using Topn 20% Using TOPN 1 - Harsh = VAR CustomerRank = RANKX( ALL( Customer ),…

Enterprise DNA TV (YouTube):

Fixing Complex Total Errors - DAX Formula Concepts

Fixing Complex Total Errors - DAX Formula Concepts

Getting Totals Correct When Using Advanced Logic - Power BI & DAX

How To Get Totals Correct When Using Advanced DAX Logic In Power BI

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand

Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand