Prakso, we are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: success.pragmaticworks.com/ondemandlearning-free-trial
Great video, explaining the learning curve of DAX is very appropriate for business users. I remember feeling very confident, then feeling lost for a while.. to master DAX, you really do need to be willing to push through.
Hi, Mark any advice for somebody just starting? I was learning the different functions DAX offers and felt pretty good about it, then I started to notice it was very hard to get my DAX measures to give me the results I was looking for. I'm currently reading the definitive guide to DAX by SQLBI, I'm on page 160 learning evaluation contexts. To be honest I feel so overwhelmed because I do understand the concepts but can't get my measures to do what I want.
I think the topics you cover here are excellent but your title of this video and description do not lend itself to getting more views. I suggest that you include topics in title and description. You deserve more views. You are a very good teacher.
Kudos to you man You have done great job I was trying to find correct total throughout the Internet I didn’t get anything now I know. Thank you man really appreciated !!this was the video I needed indeed
Thank you very much for this content. You've given exact answers to the questions that I cannot find anywhere else in the internet. I totally relate to the learning curve presented and hopefully I can make important progress to the report I am building.
Hi Ram... thanks for the feedback. We are glad to hear that this video was helpful to you. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
Hi, Great video. Thank you. But wish to point out that the "Total Home on the Market" (53 min), is still incorrect. The meaning of the formula is that, the home listed and sold in the same year. So if we look at 2012- total listed is 260, so the value for "Total home on the market" can not be more than 260. Please clarify.
Hi Mitch, this is an awesome application for a person such as myself who works in the hospitality industry. How can I modify the LASTDATE to show as of yesterday? I am trying to dictate a measure that says if it is before today use ACTUAL otherwise use the FORECAST. Thank you so much! Additional: I was able to find a solution for it. Thanks again.
Glad you liked it. Tarcisio, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Thanks for a nice video! Can someone intuitively explain the first argument of ALL()? Why did he chose 'Geography'[Country] for calculating total sales? What if he chose 'Geography'[State] or anything else?
Excellent explanation, thanks for sharing!!! Just one question about your Dynamic Measure. Is it going to work in case you have a completed month without a sale order in its last day? Like a last sale order date on July 30 instead of July 31st?
Thanks for the feedback. I am not sure if you know, but we offer many On-Demand Learning courses in case you need more training. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Good video. But I wouldn’t call this ‚advanced‘ DAX These are fairly basic DAX calculations that you learn through the beginning. Something I would really like to see more of is how to nest iterator functions to perform calculations on a groupBy level. For example if I have a sales order table with sales id and customer number, how do I perform calculations by grouping by customer Nr and then having evaluations made by that grouping. These start to get fairly complex from the beginning so I would love to have some structured introduction to those types of measures.
“Total homes on Market” calculation is wrong ? It shows sold within the year that were listed before end of year. It doesn’t show listed but unsold from this and previous years.... Help me pls..... thanks
Hello and thanks for your comment. In this example, the calculation is correct because the data set only contains homes that sold. However, if the data set also contained homes that had not sold or were still on the market, then an additional filter would need to be added! In this case the calculation is correct, thanks.
Great question Raphale. There were 8 homes that were listed prior to 2011 that eventually sold in 2012 (7 in 2010 and 1 in 2009) but the date table included in the data model started at 1/1/2011 and therefore we don't see the quantity listed for prior years.
@@MitchellPearson I was thinking this was the reason. But then why do those 8 homes listed prior to 2011 not appear in an "Unknown" bucket in the "Quantity Listed" measure?
The presenters for pragmatic works seem to love, and I mean LOVE deleting the first letters they type because the switching between upper and lower case. wHy Do tHEy mistypE eveRy singLE MeaSure tiTLE?
@@HarishKumar-cg7en... we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg There... you will find very structured courses designed for this purpose. Hope this helps. Thanks!
@@HarishKumar-cg7en Gosh , it is not India, leave your cast system mentality at the door. Why is it always someone else fault or responsibility to get everything served and arranged to you people. Where is dataset ? Where are your manners ? If you can’t think of getting any dataset from web , then go back to school and learn how to think for yourself. No one is your server here in western society. If you want to order people around stay within your territory , kopish
i seriously want to give you the feedback...you ate up our valueable first 15 mints to actually start telling about DAX why you guys can not tell us in straight way...you talk a lot but no productivity ....ridiculus video...
I am just awestruck by the clarity of his thoughts ..Doesn’t do it for you. It does miracles for me. Why the negativity? Just move on to the other videos that work for you. What a sad world we live in.
![DAX Filter Context Basics [Full Course]](http://i.ytimg.com/vi/Rpa8mDH7mes/mqdefault.jpg)
![DAX Filter Context Basics [Full Course]](/img/tr.png)
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](http://i.ytimg.com/vi/eKgcLcrebzI/mqdefault.jpg)
******STEP BY STEP******
10:07 Variable: VAR + RETURN
13:30 Working with variables
******MEASURE*****
20:24
1 Dynamic Measure =
2 VAR LastSaleDate = LASTDATE('Internet Sales Filtered'[Order Date]);
3 VAR LastDayOfMonth = LASTDATE('Date'[Date]);
4 RETURN
5 IF(LastSaleDate LastDayOfMonth;
[Forecast YTD Sales]; [YTD Sales])
******FILTER CONTEXT******
23:24 CALCULATE
24:53 ALL
29:06
1 % of Total =
2 DIVIDE ([Total Sales];
3 CALCULATE([Total Sales];
4 ALL('Geography'[Country])))
34:53 FILTER
37:04
1 Quantity Sold =
2 COUNTROWS('MLS Data')
40:19
1 MLS Data 2016 =
2 FILTER('MLS Data';
3 YEAR('MLS Data'[Sold Date]) = 2016)
43:26
Quantity Listed =
2 CALCULATE([Quantity Sold];
3 USERELATIONSHIP('Date'[Date]; 'MLS Date'[Listing Date]))
52:05
1 Total Homes on Market =
2 CONTROWS(
3 FILTER(
4 ALL('MLS Data');
5 'MLS Data'[Sold Date] >= MIN('Date'[Date]) &&
6 'MLS Data'[Listing Date]
Excellent explanation to the Advance DAX functions in easy way. I like the comparison of using %ge to grand total and using DAX.
Prakso, we are glad to hear that you liked the video. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: success.pragmaticworks.com/ondemandlearning-free-trial
Great video, explaining the learning curve of DAX is very appropriate for business users. I remember feeling very confident, then feeling lost for a while.. to master DAX, you really do need to be willing to push through.
Thanks Mark!
Hi, Mark any advice for somebody just starting? I was learning the different functions DAX offers and felt pretty good about it, then I started to notice it was very hard to get my DAX measures to give me the results I was looking for. I'm currently reading the definitive guide to DAX by SQLBI, I'm on page 160 learning evaluation contexts. To be honest I feel so overwhelmed because I do understand the concepts but can't get my measures to do what I want.
Just want to let you know that this video help me a lot ! Great work !
Mitchell I feel like I must pay for all your stuff. Your videos are are just Awesome! Thanks for this cool stuff
Thank you for watching! If you are interested in more Pragmatic Works training, please feel free to email training@pragmaticworks.com :)
I love all your videos. It's easy to understand for beginners like me. Thank you so much for posting!
Thank you for watching!
Hats off! Crisp and with clarity
Glad you enjoyed!
very clear explanation, thanks a lot for sharing.
Great work! Thanks from Finland ! 😊
I think the topics you cover here are excellent but your title of this video and description do not lend itself to getting more views. I suggest that you include topics in title and description. You deserve more views. You are a very good teacher.
I did this as a webinar, didn't realize it had been posted on UA-cam, a better title may be appropriate! Thanks for the feedback Richard.
Great tutorial video! Thank your for tips and tricks. Your video helped me to solve a puzzle in my learning process. Thank you again.
Thanks for your comment and I'm glad the video helped!
This channel is amazing, It really adds some difficulty on power BI. I was tired of beginners tutorials
Glad you enjoyed!
Kudos to you man You have done great job I was trying to find correct total throughout the Internet I didn’t get anything now I know. Thank you man really appreciated !!this was the video I needed indeed
We are glad to help!
Great video with detail explanation and guidance. Thank you very much
Thank you very much for this content. You've given exact answers to the questions that I cannot find anywhere else in the internet. I totally relate to the learning curve presented and hopefully I can make important progress to the report I am building.
Hi Ram... thanks for the feedback. We are glad to hear that this video was helpful to you. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.
@@PragmaticWorks where is student file for this video? please help me out
Excellent way of explaining, thanks for the video.
Can you please send the link to download this excel sheet for practice?
where to get the excel file that you are using?
Hi, Great video. Thank you.
But wish to point out that the "Total Home on the Market" (53 min), is still incorrect.
The meaning of the formula is that, the home listed and sold in the same year.
So if we look at 2012- total listed is 260, so the value for "Total home on the market" can not be more than 260.
Please clarify.
Awesome explanation! Great skills!
Fantastically helpful video!
Good one.. Really helps....
is there a certification of completion?
The USERELATIONSHIP function would be really helpful a long time ago for me. Thanks a lot.
We are glad to hear that!
Thank You ,
please
language MDX That used in PivotTable
Is it related to DAX
and Are there any educational materials for this language?
لا يا محمد ملهاش علاقة
Dax حاجة
MDX حاجة
عموما ال MDX
مش هتحتاج تتعلمها في الاول ..عادي يعني
@@fadwa2413 محتاج مقاطع تعليمية لل
mdx
@@Reduce_Scan تابع
documentation
Hey nice video! Where can we find the data set of the example?
Hi Mitch, this is an awesome application for a person such as myself who works in the hospitality industry. How can I modify the LASTDATE to show as of yesterday? I am trying to dictate a measure that says if it is before today use ACTUAL otherwise use the FORECAST. Thank you so much!
Additional:
I was able to find a solution for it.
Thanks again.
Nice webinar. Thanks for sharing.
Glad you liked it. Tarcisio, I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Thanks for a nice video! Can someone intuitively explain the first argument of ALL()? Why did he chose 'Geography'[Country] for calculating total sales? What if he chose 'Geography'[State] or anything else?
Hello, please give us the dataset link so that we can practice as well. Thanks.
thks bro. but without files attached. it has limited usage....
Thanks for the video!
Excellent explanation, thanks for sharing!!! Just one question about your Dynamic Measure.
Is it going to work in case you have a completed month without a sale order in its last day?
Like a last sale order date on July 30 instead of July 31st?
Great tutorial
Thanks for the feedback. I am not sure if you know, but we offer many On-Demand Learning courses in case you need more training. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
Great videos !
Glad you like them!
Does anyone have a pbix sample that Mitch used in this video?
Thanks bro
You're, welcome.
Thanks for sharing. is there a link to download the files used in this video? if so, could you please share it with us ? thanks in advance
Hi..can anyone say the diff between quantity listed vs total homes on market.and why we are using all(mlsdata) in last dax
very helpful
Thanks Helen.
Good video.
But I wouldn’t call this ‚advanced‘ DAX
These are fairly basic DAX calculations that you learn through the beginning.
Something I would really like to see more of is how to nest iterator functions to perform calculations on a groupBy level.
For example if I have a sales order table with sales id and customer number, how do I perform calculations by grouping by customer Nr and then having evaluations made by that grouping.
These start to get fairly complex from the beginning so I would love to have some structured introduction to those types of measures.
Great content, even 4 year later :)
Great tutor
Thank you.
Great Video, tks for the content!
Thanks Fernando, I'm glad it helped.
thanks for the video. Would you please to share data model file?
So I am a few years late but maybe still someone can explain how at 53:06 Total homes on market at 2011 can be more than listed homes?
“Total homes on Market” calculation is wrong ?
It shows sold within the year that were listed before end of year.
It doesn’t show listed but unsold from this and previous years....
Help me pls..... thanks
Hello and thanks for your comment. In this example, the calculation is correct because the data set only contains homes that sold. However, if the data set also contained homes that had not sold or were still on the market, then an additional filter would need to be added! In this case the calculation is correct, thanks.
40:05 Oops :) great presentation, thx!
I started out in and am stuck in the Anger Phase.
Is it just me, or is the audio quality not so great on this video?
Can anyone explain why there are 111 homes on the market when there are only 103 homes starting listed in 2011?
Great question Raphale. There were 8 homes that were listed prior to 2011 that eventually sold in 2012 (7 in 2010 and 1 in 2009) but the date table included in the data model started at 1/1/2011 and therefore we don't see the quantity listed for prior years.
@@MitchellPearson That's very helpful! Thank you so much!
@@MitchellPearson
I was thinking this was the reason. But then why do those 8 homes listed prior to 2011 not appear in an "Unknown" bucket in the "Quantity Listed" measure?
i waiting for the nexts
The presenters for pragmatic works seem to love, and I mean LOVE deleting the first letters they type because the switching between upper and lower case. wHy Do tHEy mistypE eveRy singLE MeaSure tiTLE?
Data Set is missing in the video ... Can you please update a link where we could download the dataset/files .
Good Morning Harish, there is no dataset for this video.
@@PragmaticWorks Then how could we practice ? Practising is important when we watch videos....
@@HarishKumar-cg7en... we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg There... you will find very structured courses designed for this purpose. Hope this helps. Thanks!
@@HarishKumar-cg7en Gosh , it is not India, leave your cast system mentality at the door. Why is it always someone else fault or responsibility to get everything served and arranged to you people. Where is dataset ? Where are your manners ? If you can’t think of getting any dataset from web , then go back to school and learn how to think for yourself. No one is your server here in western society. If you want to order people around stay within your territory , kopish
51:22 😂😂😂😂
LOL, I had forgotten about that one 😀 -Mitchell Pearson
Sorry, how is this advanced DAX?
SQLBI explains things very difficult. Too much in detail or technical.
Do you have any other sources? I'm reading their book the definitive guide to DAX but I'm kind of overwhelmed, too much information
@@santiagowilches4276 just watch YT from other experts.
I'm in angry phase
Nah i dont see thismadvance
i seriously want to give you the feedback...you ate up our valueable first 15 mints to actually start telling about DAX why you guys can not tell us in straight way...you talk a lot but no productivity ....ridiculus video...
Says someone who cannot spell ridiculous. This is a good video, if you didnt like it, just skip forward.
I am just awestruck by the clarity of his thoughts ..Doesn’t do it for you. It does miracles for me. Why the negativity? Just move on to the other videos that work for you. What a sad world we live in.
Sorry you were disappointed. I try to avoid slides when and where I can, I appreciate the critical feedback and will learn from it!
@@MitchellPearson amazing video
Great Tutor
Thank you