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

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 *****
—

***** Learning Power BI? *****

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

[richardmartin]

Man I would love to see more content like this. Like a lot more. Its hilarious to me how Greg is like here is this easier to understand way to do something without calculate and I get what he is doing right away. I am curious though if you can always avoid calculate.

[rishichaitali]

This is outstanding. I was wrapping my head around this for a long time, and you made it so easy to understand.

[GoofyGooble]

This really makes sense, thanks, please upload more contents related to Quick Measures.

[samuelvecchio]

What if i have ti calculate this average for the previous year?

[ThothAmon]

Ironic I was just digging into this today building a query; but how can I run this over two categories that average over the value column over a specific date range (DATESINPERIOD; basically getting the last three months)??

[djl]

Make a video where you take raw transactional data and do averages for so we can reference it.

[tomaszs]

In terms of performance how does it compare to calculate?

[welcometomathy]

What if I want to avg by monty the value of a measure lets