How To Easily Fix Incorrect Measure Totals In Power BI

[@EnterpriseDNA]

Check out our FREE courses: bit.ly/3N00AJw

[@luisbarria4388]

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

[@jujufina1]

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?

[@mercydabbs3330]

Really a rant! Thank you.

[@MarkAzali]

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

[@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

[@prod2one]

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!

[@Mehlbaum97]

You're a saint! Thanks so much!

[@GregKramerTenaciousData]

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

[@lionels839]

Hello How to fix incorrect average on the total lines?

[@EnterpriseDNA]

Hello Lionel, We're providing a link of the post which was created by our in-house expert onto the Community Forum which contains links about how to fix totals pertaining to this topics specifically. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on Power BI, Power Platform, and the Microsoft stack updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/ kzbin.info/www/bejne/jpe4lmxnas17bdk forum.enterprisedna.co/t/fix-incorrect-totals/8834

[@nominini90]

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 ...............How to fix this error ?

[@EnterpriseDNA]

Hello Muhammad, It's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And in this case, we also don't know at which place you committed the error as well as while performing what operations. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful! If you haven't yet, you can subscribe to our KZbin channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@Wzxxx]

The whole BI is a barrier in every aspect. Every simple math calculation or idea😁(simple!) is taking hours to create. In addition there is no debugging tool or any view one can take a look what is going on behind a measure or what is filtered etc). 90% chance it will be wrong as there are so many things needed to considered. After 2 years I really hate it as all ideas are horror to implement.

[@benlyon5398]

While I can appreciate the shortened versions of your DAX code, it's very difficult to follow the "___Value" in your final summary SUMX. If would help if this was spelled out to better explain the Summarize formula. I am darn near an expert is Excel, but this formula is just a seemingly big mess and Microsoft can't even explain it well in their "Learn Microsoft" pages.

[@etherlords88]

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.

[@EnterpriseDNA]

Hi @etherlords88 - we hear you. Hopefully Microsoft can have this fixed real soon!

[@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

[@texmexdragon2160]

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

[@EnterpriseDNA]

Hi TexMexDragon, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@dana_padrino]

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

[@joefromdc]

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

[@jeffalex]

me too.. did you figure it out?

[@DeronHuskey]

Simple, to-the-point example. Thanks.

[@EnterpriseDNA]

Hi Deron, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@AshAsmodeus]

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

[@EnterpriseDNA]

Hi Ferrie, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@AshAsmodeus]

@@EnterpriseDNA I feel so stupid now... I thought I actually did but hadn't... thanks for pointing it out :)

[@sudarsana1234]

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

[@EnterpriseDNA]

Hi @sudarsana1234, glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

[@sudarsana1234]

@@EnterpriseDNA already taken subscription 👍

[@markdoucette9870]

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

[@Alan12112]

thanks for this

[@naveens4793]

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

[@alessandralee1694]

How do you use the summary table?