Calculate The Total Of Average Results In Power BI Using DAX

I've seen this requested many times on the Enterprise DNA Support Forum and elsewhere. How can you calculate the total of averages within Power BI using DAX? In this tutorial, I run through how you need to combine many DAX formula techniques to get the correct results. I run through AVERAGEX, HASONEVALUE and SUMX functions. I also show how you can branch out from this result to calculate additional interesting insights. ***** Video Details ***** 0:47 Looking Into The Formulas 1:06 Total Sales Formula 2:00 Average Results Formula 2:58 Calculating Total of Averages 5:14 How You Can Use This Technique ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Cumulative Totals Across Averages & Dynamic Date Logic – Advanced DAX https://blog.enterprisedna.co/2018/10/01/cumulative-totals-across-averages-dynamic-date-logic-advanced-dax/ Calculating % Of Totals https://blog.enterprisedna.co/2016/10/12/calculating-of-totals/ Cumulative Totals In Power BI Without Any Dates – Advanced DAX https://blog.enterprisedna.co/2018/10/05/create-cumulative-totals-no-date-no-index-advanced-dax-techniques-in-power-bi/ ***** Related Course Modules ***** Mastering DAX Calculations http://portal.enterprisedna.co/p/mastering-dax-calculations Scenario Analysis Deep Dive http://portal.enterprisedna.co/p/scenario-analysis-deep-dive DAX Formula Deep Dives http://portal.enterprisedna.co/p/dax-formula-deep-dives ***** Related Support Forum Posts ***** Grand Average Total In Table https://forum.enterprisedna.co/t/grand-average-total-in-table/379 Percentage Of Total Sales Average By Fiscal Year https://forum.enterprisedna.co/t/percentage-of-total-sales-average-by-fiscal-year/1034 Measures Not Calculating Sum In Matrix https://forum.enterprisedna.co/t/measures-not-calculating-sum-in-matrix/745 For more average total queries to review see here….. https://forum.enterprisedna.co/search?q=average%20total