When you start writing more advanced DAX formula, your totals will likely start playing up and not returning the values you want. In this tutorial, Sam demonstrates how to use a technique that will get you the correct totals particularly when using advanced DAX logic.

*****Video Details*****
00:00 Introduction
01:11 The objective
01:45 Total sales
02:15 Monthly averages
03:37 Average yearly result
05:24 Incorporating HASONEVALUE

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial