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

Подписаться 92 тыс.

Просмотров 17 тыс.

50% 1

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 - community.powerbi.com/t5/Quic...
-
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - www.enterprisedna.co/power-bi-...
FREE - 60 Page DAX Reference Guide Download - www.enterprisedna.co/dax-form...
Enterprise DNA Membership - www.enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - www.enterprisedna.co/enterpri...
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@EnterpriseDNA Год назад

Check out our FREE courses: bit.ly/3N00AJw

@samuelvecchio6758 10 месяцев назад

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

@GoofyGooble Год назад

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

@richardmartin7904 Год назад

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.

@EnterpriseDNA Год назад

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

@chioke123us1 9 месяцев назад

Thank you ❤

@rishichaitali 4 месяца назад

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

@Thoth0Amon Год назад

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)??

@EnterpriseDNA Год назад

Hello Thoth0Amon, It's always a little bit difficult to judge and provide the results 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. Hoping you find this useful! If you haven't yet, you can subscribe to our RU-vid channel so that you won't miss out on any Power BI & Power Platform 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/

@Thoth0Amon Год назад

@@EnterpriseDNA Thanks, I'll check out the Community Forum. I did find a solution in my particular case; the trick was using ALLEXCEPT nested in a calculated column inside SUMMARIZECOLUMNS. Sort of weird compared to a similar case using SQL where you'd pivot or something, but it works for setting up multiple groupings under one table summary. The Averaging part was done by using DATESINPERIOD and dividing out the columns by that period.

@jussiviinamaki6498 5 месяцев назад

Thank You, So much!!

@brunohenriquedecastroevald2074 Год назад

Thanks! Helped me a lot!

@welcometomathy Год назад

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

@EnterpriseDNA Год назад

Hello WelcomeToMathy, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, the query which you've raised is not clear to us here. Can you please re-post the query by elaborating the scenario that you're trying to achieve? Or else provide the proper PBIX file by posting the query along with the description 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 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/

@tomaszs4188 Год назад

In terms of performance how does it compare to calculate?

@EnterpriseDNA Год назад

Hello Tomas, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. To learn about the performance optimization, we've created a dedicated course available onto our Enterprise DNA education portal. Below is the link of the course provided for the reference. 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! 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/ app.enterprisedna.co/app/player-course/24 app.enterprisedna.co/app/player-course/23

@Alma-im4qk 9 месяцев назад

You talk funny and deep!

@hamishmaxa6509 Год назад

This was really good.

@EnterpriseDNA Год назад

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