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
Hi! Thank you very much for the video! Is brilliant! One question, how can we handle the incorrect totals of your last example if we have field parameters for dynamic selection of rows in a matrix?
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.
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 ?
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?
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?
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
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.
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
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.
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??
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%)
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?
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.
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.
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?
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.
Folks, the totals demonstrated in this video are NOT wrong at all. There should not be a total for MAX. And yes, the total max of all categories is also the total max of the category with the highest max. Regarding unique values, the unique values of a total can be lower than the total unique of all categories. This is CORRECT. There are other occasions where Power BI can confuse the totals, around averages, but that's not the case in this video. Totals are not always a must.
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.
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
dear can you guide how to join line in line chart if line graph if some month data not available, line shows disconnected chart
Ohh Chandeep
You have saved our dashboards from this total error. Thank you so much. We will circulate this useful tutorial.
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!
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
Awesome explanation, I was lost on that issue, but now I understand a bit more, thanks!!!😊
I've said something similar before, but you have a gift for explaining concepts.
Thanks for this.
OMG!!! You are AMAZING! Perfect instructions, I can’t believe I did it! You totally saved my a$$!!!
You're welcome, I'm here to save your a$$ 😉
This was SUPER helfpul! Your examples and explanations made this very easy to learn. Thanks Chandeep!
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!
thank you, this explanation saved my sanity, had a report published with correct row amounts but overall total was wrong, cheers
As always getting to the heart of the matter. Excellent tutorial Chandeep.
dude that sumx value calculate nailed it! thanks a bunch
As Jet Li, you are the One ^^. Thank you for this amazing solution
Thank you for this video, it was very helpful!
Hi! Thank you very much for the video! Is brilliant! One question, how can we handle the incorrect totals of your last example if we have field parameters for dynamic selection of rows in a matrix?
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.
Excellent explanation! 👍🏼Thanks!
That was very helpful! Thank you
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 ?
Thank you so much bro, I was struggling with this since couple of days .. great help
Can the same be achieved with Summarize( addcolumns( max(sales), "day", (uniquedays))
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?
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?
That was awesome, thanks Chandeep
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
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.
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
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?
Wow Wow.. You are wonderful... Best Video.. 👍
Hey goodly guru
Grand total is not showing for measure in table matrix
Please help me out
After watching this, I have many measures to rewrite 🤣! Thank you!
Thank you! Great video as usual!
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.
You are a savior! Thank you so much!
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??
On excel there is a formula avedev. What is the formula on power query? Thx in advance
Cool video and THANKS for the Greg Deckler reference, plz vote everybody!
You are an amazing teacher🎉
Greg's Dilemma !! 😄,Chandeep where is the meme for the video cover..😂
Nice,nifty tip on dax studio to convert the value.
You're great! Saved my day!
fantastic explanation!!! thank you
Thank you chandeep it helped a lot.
Sandeep Bhai So much !!!! otherwise this Total Error was making me crazyy
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%)
Wow man, salute to you.
Hello
just i want to ask abaut your M- query kurs
it is on your Chanel ????????????????????????
Tell me please.
Please can you send me your Email
Thanks in advance
This is bananas 🍌. Simply mindblowing 🎉.
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?
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.
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.
agreed. would love a dax studio vid
Yes please make a series on DAX Studio
Thank you Sir I got a solution from your video and example
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?
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.
Folks, the totals demonstrated in this video are NOT wrong at all. There should not be a total for MAX. And yes, the total max of all categories is also the total max of the category with the highest max. Regarding unique values, the unique values of a total can be lower than the total unique of all categories. This is CORRECT. There are other occasions where Power BI can confuse the totals, around averages, but that's not the case in this video. Totals are not always a must.
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?
Thank you!
Hello man, will I have lifetime access to the online courses once I have enrolled? Thanks.
Yes
Excellent!!
How can we repeat all labels in Matrix (row wise)
Use a table visual
@@GoodlyChandeep if I am using table visual then how can I freeze the row
Super bro... Thanks
Thank you so much ❤
I accept whatever Power BI gives me as the true and accurate total. Life is less stressful that way.
Hello professor, thank you to give me good video.
Can you upload about powerbi the hierarchy tools?
Ex) humen data, humen image
Kindly make a video on Granularity
Great video, but i need to do this in the other way.
Take unique values for total but spread in categories
Thank you!
Great, thanks.
Hi Bro i need your help
The actual / vanilla numbers seemed correct.
But then, yeah, as per the use case, these "fixes" come in handy as well.
Awesome
Why power bi fixed it ?
Boom nice
Can't view what you are showing on screen
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.
got it.. i'll do better next time :)
Thanks Godly
Genius
I want to join dax program
goodly.co.in/products
I was also thinking the sum was roughly 600 and not 700.
This is some curse.
Gold
Manually adding the rows to get a total makes no sense
i love u
🆒🎉
Is it a problem, or a feature? Hmm.
Should be an option to select?