Home » Education » How To Get Better Average Per Category In DAX - Why You Should Not Use CALCULATE

How To Get Better Average Per Category In DAX - Why You Should Not Use CALCULATE

Written By Enterprise DNA on Friday, Sep 16, 2022 | 10:00 AM

 
In last month’s Business Intelligence Summit, one of our speakers, Greg Deckler, presented about DAX counterculture wherein he talked about alternative uses on DAX. One of his key topics is all about the DAX function CALCULATE and why you should avoid using it especially if you’re new to DAX. In this tutorial, Greg is going to pick up on that discussion and delve into another Microsoft quick measure —Average Per Category. ***** Video Details ***** 00:00 Introduction 01:54 The goal 02:07 Data model 02:55 Average per Category measure 06:00 Better Average per Category measure ***** Related Links ***** Better Average per Category - https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Average-per-Category/td-p/2758871 — ***** 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 - Power BI Resources - http://www.enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://www.enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://www.enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial