How to fix Incorrect Totals in Power BI

Подписаться 96 тыс.

Просмотров 51 тыс.

50% 1

In this video, we will discuss the reasons behind incorrect totals in Power BI and how to fix them. We will explore examples and demonstrate the solutions step by step.
#PowerBI #IncorrectTotals #DataAnalysis
Row Context and Context Transition - • Row Context and Contex...
Context Transition in Power BI and Tricky Examples - • Context Transition in ...
Simple and Powerful Context Transition Examples in Power BI - • Simple and Powerful Co...
Vote Here 📍- ideas.fabric.m...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step by Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/h...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

Опубликовано:

13 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 84

@GoodlyChandeep Год назад

Download the File ⬇ - goodly.co.in/how-to-fix-incorrect-totals-in-power-bi/ Join the waitlist for Power Query's M Language course↗ - subscribepage.io/Learn_Power_Querys_M_Language

@pradeepadhav 11 месяцев назад

dear can you guide how to join line in line chart if line graph if some month data not available, line shows disconnected chart

@petercompton538 4 дня назад

This is brilliant - the problem comes up all the time. It is so useful to understand that you need to create "parallel" tables. Thank you

@lukev730 7 месяцев назад

Ohh Chandeep You have saved our dashboards from this total error. Thank you so much. We will circulate this useful tutorial.

@yoyispao 11 месяцев назад

Awesome explanation, I was lost on that issue, but now I understand a bit more, thanks!!!😊

@groman310 7 месяцев назад

This was extremely helpful. I spent days looking at our totals in a certain matrix and this method solved the issue. Thank you so much!

@Torres8631 5 месяцев назад

Thank you so much for this video. I was struggling with figuring out how to do it when there was a matrix. You made my day!

@sabzchetty 20 дней назад

Excellent explanation! 👍🏼Thanks!

@Si_inkart 8 месяцев назад

thank you, this explanation saved my sanity, had a report published with correct row amounts but overall total was wrong, cheers

@santiagodagostino1465 Месяц назад

You are a savior! Thank you so much!

@alexkim7270 3 месяца назад

Thanks for explaining. I've been wondering, for the longest time ever why do I always have many people complaining about the total rows that don't add up. I now understand it is as I suspected. Non-additive measures. I would actually consider ISINSCOPE for some cases.

@gustavobarbosa906 11 месяцев назад

After watching this, I have many measures to rewrite 🤣! Thank you!

@IvanCortinas_ES 10 месяцев назад

As always getting to the heart of the matter. Excellent tutorial Chandeep.

@indiapradeep2008 5 месяцев назад

Thank you so much bro, I was struggling with this since couple of days .. great help

@ayushtiwari5665 Месяц назад

Thank you chandeep it helped a lot.

@BISimplifier 11 месяцев назад

Greg's Dilemma !! 😄,Chandeep where is the meme for the video cover..😂

@eimantez.8566 8 месяцев назад

That was very helpful! Thank you

@OneNI83 11 месяцев назад

Nice,nifty tip on dax studio to convert the value.

@leoncastro3073 11 месяцев назад

What a great video, I could not find a better explanation in Spanish. Thank you very much. Is it possible to make examples with averages and that in the totals of the power bi table or matrix the average of everything is shown and not the sum of them. Thanks again, greetings from Colombia.

@pierre-louisviala3191 11 месяцев назад

Thanks a lot Chandeep ! As usual : Smart, concise explanation, excellent teacher ! I think that PowerBI is misleading with bottom line called "Total" ; I would prefer instead "All" or even better to let the user define the bottom row header

@enocharthur4322 9 месяцев назад

Thanks for much for this @GoodlyChandeep. This is excellent! Do you have any update on the status of the vote you spoke about at the end of your video?

@chrism9037 Год назад

That was awesome, thanks Chandeep

@learningsessions4584 5 месяцев назад

Hi Chandeep, thanks for this brilliant video. Can you please point me to any such of your video where I want to have percentage of grand total along with values by category. Not the simple percent of grand total but percentage at each level & addition of all such percentage ( which will be 100%)

@vasilisa6128 10 месяцев назад

Thank you! Great video as usual!

@alterchannel2501 5 месяцев назад

You are an amazing teacher🎉

@williamarthur4801 11 месяцев назад

Funnily enough prior to this I was re watching a vid on Semi additive measures for end of month, BTW have you thought of doing a video on DAX studio, I find it very useful, but only use a fraction of the features available.

@silentflight1 11 месяцев назад

agreed. would love a dax studio vid

@anikeetdey3411 11 месяцев назад

Yes please make a series on DAX Studio

@MoonShine-bs6cl 8 месяцев назад

Hi awesome explanation, but i have a doubt if you could make a video on the running total by category and put it as a Top N, so how do i get the correct total when topn values are selected... Pls help

@Henrik.Vestergaard 11 месяцев назад

Cool video and THANKS for the Greg Deckler reference, plz vote everybody!

@user-cz2yu1li2q 2 месяца назад

Can the same be achieved with Summarize( addcolumns( max(sales), "day", (uniquedays))

@hen3hao3 4 месяца назад

You're great! Saved my day!

@tommynguyen4253 11 месяцев назад

The issue with the fix is NOT dynamic. Whenever you change the attribute, it wont work anymore. If we have some function opposite to ALLSELECTED (eg. ALLNOTSELECTED), then it would make it easier.

@mariaalejandraalfonsomunoz1737 7 месяцев назад

Thanks for your input. But I need the opposite. In my case The total is correct, but I need to focus on fixing values within rows. In your initial example with CHANNEL and UNIQUE DAYS, I want to show a non-duplicated total of 464, considering only unique days for 'Affiliate,' 'Organic,' and 'Promotional' channels. Can you help me count only once time the same day across these three channels?

@andybecker9627 9 месяцев назад

fantastic explanation!!! thank you

@jadhavbanjara6306 6 месяцев назад

Thank you Sir I got a solution from your video and example

@siddheshamrutkar8684 11 месяцев назад

Wow Wow.. You are wonderful... Best Video.. 👍

@Fabrizioea 6 месяцев назад

Great video, but i need to do this in the other way. Take unique values for total but spread in categories

@hopebirdsong2847 4 месяца назад

Chandeep, I loved your video. although, I am receiving incorrect totals for the following measure: Notes within Admission = CALCULATE(DISTINCTCOUNT('TABLE[signature date], FILTER(table, table[admitDate] = table[signatureDate] Is there a way to write the dax code so that it totals the above outcome per row?

@sabzchetty 20 дней назад

Summarize the table/columns then SUMX it. Basically forcing context in that measure and summing whats only available in that context. Hope it makes sense.

@cindypoh9766 Месяц назад

Hi Can you help me? Everytime when i use SUMMARIZE or SUMMARIZECOLUMNS, i get below errors: Couldn't load the data for this visual MdxScript(Model) (299, 5) Calculation error in measure 'TABLE'[measure]: SummarizeColumns() and AddMissingItems() may not be used in this context.

@navisalomi 8 месяцев назад

This is bananas 🍌. Simply mindblowing 🎉.

@nikakalichava8012 11 месяцев назад

good one already been using these methods! goodly, can you help me with 1 problem? I have a data for 2023 sales, but each row is a cumulative for previous... Lets say I have 2 sales reps, 1 sold 200$ and other 400$ in Sep-1, and 1 sold 300$ and other 0, the data comes Sep 1 ; Sales rep 1 ; Sales 200 Sep 1 ; Sales rep 2 ; Sales 400; Sep 2; Sales rep 1; Sales 500; (is accumulates from the start of each month); Sep 2; Sales rep 2; Sales 400... I have 3 measures measure 1 - sum ( Table[sales] ); measure 2 - calculate ( [measure 1] , PREVIOUSDAY (table[date] ) measure 3 - [measure 1] - [measure 2] and it works fine but.... I have to use a Direct Querry.... I want to make a matrix (Months in columns and days (1-31) in rows.. it works but I also had to make a new visual by weekdays and it does not work... :( any tips?

@user-jr2uc8sw6n 11 месяцев назад

Hello professor, thank you to give me good video. Can you upload about powerbi the hierarchy tools? Ex) humen data, humen image

@kommabalaji4845 11 месяцев назад

Kindly make a video on Granularity

@allendataguy 5 месяцев назад

The actual / vanilla numbers seemed correct. But then, yeah, as per the use case, these "fixes" come in handy as well.

@austinstubetv 11 месяцев назад

Thank you!

@loganathannainar4804 11 месяцев назад

Excellent!!

@madhurilathameejuri 7 месяцев назад

I am facing an issue with my data , when displayed on card it shows a value based on measure id , but the same value when im taking on measure name its throwing a different value. How can i resolve it ?

@shivanihandore4738 11 месяцев назад

Thank you so much ❤

@anushiyag-yl9je 10 месяцев назад

Super bro... Thanks

@sheshikumarausheni9428 10 месяцев назад

Hey goodly guru Grand total is not showing for measure in table matrix Please help me out

@januszb4494 11 месяцев назад

Hi, I have data for every month file but every file is running total from January, how to calculate in dax sales for every single month?

@megabuilds3007 11 месяцев назад

Great, thanks.

@shankaricharan510 5 месяцев назад

Thanks Godly

@gamehub8068 11 месяцев назад

Sir mere office me pahle mail send arane ki limit nahi thi but ab 50 logo ko hi mail send kar sakte hai to uska koi upaye hai ki group bana ke 400 logon ko send kar sakte hai kya??

@shapirit12 11 месяцев назад

What is the point of totaling max in the first place? Showing the total is not always relevant. What is the point of summarizing max?

@user-of9ku1qw3s 5 месяцев назад

Hi Raj, how do I get in contact with you?

@punchbuddies220 11 месяцев назад

Hello man, will I have lifetime access to the online courses once I have enrolled? Thanks.

@GoodlyChandeep 11 месяцев назад

Yes

@gkirankumarskht 11 месяцев назад

Awesome

@AA-kq8on 11 месяцев назад

Hello just i want to ask abaut your M- query kurs it is on your Chanel ????????????????????????

@GoodlyChandeep 11 месяцев назад

Tell me please.

@AA-kq8on 11 месяцев назад

Please can you send me your Email Thanks in advance

@2000mamos 4 месяца назад

Hi Bro i need your help

@AshikKhan-er4up 11 месяцев назад

How can we repeat all labels in Matrix (row wise)

@GoodlyChandeep 11 месяцев назад

Use a table visual

@AshikKhan-er4up 11 месяцев назад

@@GoodlyChandeep if I am using table visual then how can I freeze the row

@MoonShine-bs6cl День назад

Can't view what you are showing on screen

@juliom6260 11 месяцев назад

Genius

@odeddror8916 11 месяцев назад

Gold

@cm386464 5 месяцев назад

🆒🎉

@hussainmeghani4809 10 месяцев назад

Why power bi fixed it ?

@muhammadasad729 Месяц назад

I was also thinking the sum was roughly 600 and not 700. This is some curse.

@sharadkumarpani7625 3 месяца назад

do you yourself have the idea why the totals are different with every change in the DAX. Unless you explain why the number 464 appears and 1396 appears how can we understand that calculate is giving the right answer. You are not showing the dataset how will we understand the difference.

@GoodlyChandeep 3 месяца назад

got it.. i'll do better next time :)