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

  Рет қаралды 18,824

Enterprise DNA

Enterprise DNA

Күн бұрын

Пікірлер: 23
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
Check out our FREE courses: bit.ly/3N00AJw
@richardmartin7904
@richardmartin7904 2 жыл бұрын
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
@EnterpriseDNA 2 жыл бұрын
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!
@samuelvecchio6758
@samuelvecchio6758 Жыл бұрын
What if i have ti calculate this average for the previous year?
@rishichaitali
@rishichaitali 9 ай бұрын
This is outstanding. I was wrapping my head around this for a long time, and you made it so easy to understand.
@Thoth0Amon
@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
@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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@Thoth0Amon
@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.
@GoofyGooble
@GoofyGooble 2 жыл бұрын
This really makes sense, thanks, please upload more contents related to Quick Measures.
@chioke123us1
@chioke123us1 Жыл бұрын
Thank you ❤
@welcometomathy
@welcometomathy 2 жыл бұрын
What if I want to avg by monty the value of a measure lets
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@tomaszs4188
@tomaszs4188 2 жыл бұрын
In terms of performance how does it compare to calculate?
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ app.enterprisedna.co/app/player-course/24 app.enterprisedna.co/app/player-course/23
@jussiviinamaki6498
@jussiviinamaki6498 11 ай бұрын
Thank You, So much!!
@Alma-im4qk
@Alma-im4qk Жыл бұрын
You talk funny and deep!
@brunohenriquedecastroevald2074
@brunohenriquedecastroevald2074 2 жыл бұрын
Thanks! Helped me a lot!
@hamishmaxa6509
@hamishmaxa6509 2 жыл бұрын
This was really good.
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
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!
@djl8710
@djl8710 2 жыл бұрын
Make a video where you take raw transactional data and do averages for Year/Quarters/Months/Days/Hours so we can reference it.
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
Hi Djl, appreciate the suggestion. We'll include this in our list of possible topics for our future videos. Cheers!
@zxccxz164
@zxccxz164 29 күн бұрын
not good. no discussion of performance.
Secondary Table Logic Inside Of Power BI Using DAX
11:39
Enterprise DNA
Рет қаралды 18 М.
Working with AverageX and Summarize to create averages in DAX
22:50
MitchellPearson
Рет қаралды 42 М.
OCCUPIED #shortssprintbrasil
0:37
Natan por Aí
Рет қаралды 131 МЛН
Air Sigma Girl #sigma
0:32
Jin and Hattie
Рет қаралды 45 МЛН
MSHGQM  - Power BI DAX - Don't Use CALCULATE!
16:46
Microsoft Hates Greg
Рет қаралды 7 М.
Calculate AVERAGE in Power BI | Power BI
20:39
Pettaka Technologies
Рет қаралды 2,1 М.
Why Power BI totals might seem wrong
27:55
SQLBI
Рет қаралды 56 М.
NEW OFFSET Function in DAX | Will It Change How You Write DAX?
19:22
How to Power BI
Рет қаралды 59 М.
Computing rolling average in DAX
16:43
SQLBI
Рет қаралды 75 М.
How to fix Incorrect Totals in Power BI
14:44
Goodly
Рет қаралды 62 М.
OCCUPIED #shortssprintbrasil
0:37
Natan por Aí
Рет қаралды 131 МЛН