Fixing Total Errors In Power BI - I Know It Can Be Frustrating

by EnterpriseDNA Regular Visitor ‎10-25-2018 07:25 PM - edited ‎10-25-2018 07:41 PM

With today's post I wanted to run through some examples of how you can solve errors in your totals within Power BI.

 

Via the Enterprise DNA Support Forum, I get to see a lot of issues and requests that users who are working in Power BI Desktop have. I would say, that likely one of the biggest issues is with totals - understanding why you're receiving certain total results and how you can actually fix these.

 

The key thing to think about especially with totals inside of Power BI is the context of the particular total where you're receiving the error or incorrect result. This may sound simple but this is usually where the misunderstanding occurs.

 

Once you understand what the context is then it becomes much easier to create logic that will fix up the error or give you the particular result that you want. (The trick here is sometimes there is no context at all and that's where it can be a little tricky.)

 

The first example is a perfect one to review to understand more about the logic behind totals. Plus, a simple technique around how you can fix them.

 

 

In this second example, we're going to get a bit more complex. You can write some complex formulas inside of Power BI and understanding how the totals are calculated for these can sometimes be a little bit more difficult.

 

So this is what this particular example is all about, how you can start creating logic around totals for even more advanced and complex formulas.

 

It's a really good one to review especially if you have some of these issues in your own analysis. This is a really key topic for high-quality development inside of Power BI.

 

 

This is clearly one of the tougher things to solve in Power BI, especially with advanced DAX functions. Invariably, you'll have some sort of total error and you'll need to work out a way to create the accurate logic to correct it. Also, you'll want to make sure the results that you're seeing are precise and what the consumers of your reports would expect.

 

Enjoy the content!

 

Sam

 

 

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

FREE COURSE - Ultimate Beginners Guide To Power BI

FREE COURSE - Ultimate Beginners Guide To DAX

FREE - 60 Page DAX Reference Guide Download

FREE - Power BI Resources

Enterprise DNA Membership

Enterprise DNA Online

 

 

 

Comments
by Niranjan209 Frequent Visitor
on ‎11-02-2018 09:35 AM

Hi,

 

I am facing issue ragarding underlaying data ,when i exporting underlaying data some of the columns are missing (used chart is Clustered bar chart),here i have used three columns among the three columns one column is measured column,here nearly have 15 columns but 9 columns only displaying in excel.what is the reason any one can help me pls.