How To Use The GROUPBY Function In Power BI - DAX Function Review 

Hi rupali, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well it's always a little bit difficult to judge and provide the results pertaining to the optimization without looking at the data structure, model and working of the PBIX file for the reference. 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. On a related note, why don't you try using a DAX approach by implementing "AVERAGE()" or "AVERAGEX()" function. We're providing few of the links of the videos from our Enterprise DNA RU-vid channel pertaining to this topic. Hoping you find this useful! You can subscribe to our RU-vid channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ ru-vid.com/show-UCy2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UcJ-pgPp5Bo.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XfUe915hH7w.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BY-5waiLp0g.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J8N4MG7U4Gg.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-byV7EcTVrwE.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WF3aZ_Ws5fc.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nQS6ZO45JNA.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-y0DdFfeuwR4.html

Hi, 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!

Hello oh moneymoneyhome, thank you for posting your query onto our channel. Well, you can use the below provided formula for the reference to calculate the "Correct Grand Total" - Max Product Sales by State - Total = SUMX( SUMMARIZE( Customers , Customers[Customer Names] , "_@Grand Totals" , [Max Product Sales By State] ) , "_@Grand Totals" , ) We're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA RU-vid channel pertaining to this topic about "How to Fix Totals". For furthermore queries, you can also reach out to us onto our Community Forum 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 as well. Hoping you find this useful and meets your requirements that you've been looking for. Happy Learning!!! forum.enterprisedna.co/ blog.enterprisedna.co/fixing-incorrect-totals-using-dax-measures-in-power-bi/ blog.enterprisedna.co/why-your-total-is-incorrect-key-power-bi-concept/ community.powerbi.com/t5/Community-Blog/Fixing-Total-Errors-In-Power-BI-I-Know-It-Can-Be-Frustrating/ba-p/552929 forum.enterprisedna.co/t/fix-incorrect-totals/8834 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Rii_6qkLNh8.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-44QUjA5NDwY.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PbkWkyKtAEw.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QkFlY9bEotI.html

@@EnterpriseDNA thank you. it works！

Hi Mehdi Hammadi, glad you appreciated the video.