Hi MitchelSQL. First of all, awesome webinar/ video. Second, I simply love the way you teach and explain things. When I had the premium account at Pragmatic, your videos about DAX are amazing. Now I want to ask you and Pragmatic team starting using zoom in / out when showing something special or when something is in explanation focus mode. Why? Because it will help people watching through mobile devices. I know it will bring you more work, but I almost gave up watching because through mobile it is hard to see measures in detail. Maybe if your audience has to stop mobile and jump to desk or notebook, they could not come back and direct to another video. :) Thanks in advance.
Nick, we are glad 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: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
I don't understand how the SUMX(Values(‘Date’[Month), Dynamic Measure works. . On a base level I get the idea but how PowerBI knows how to do it confuses me. I get that Values() returns a single column table of the values of each month. Easy. But when the Dynamic Measure runs how does it know that the list of months in the Values(‘Date’[Month]) table are dates and not just a table of text strings. When the Value() function executes does it retain all the associated relationships? I am obviously reading something wrong. In my mind DAX is saying LastSaleDate in the Dynamic Measure would be evaluated on the table Values(‘Date’[Month]), but its just a list of strings. LastSaleDate looks for the max orderdate on the sales table. January isn't a date. What am I missing?
Hey Tom, Remember everything works within the existing filter context, therefore the months are still part of the date table and the date table is filtering the sales table through the active relationship, in this case, the order date. If I were to remove the year from the report, then that would be removed from the filter context and we would see completely different results, this helps to validate that filter context is taking place. I hope this helps a little. If you want you can email me directly. Thanks, Mitchell
![Advanced DAX: Problem, Design, Solution [Heavy Demo]](http://i.ytimg.com/vi/eKgcLcrebzI/mqdefault.jpg)
Thank you! Great video, very helpful!
Glad it was helpful! Thanks for watching!
Great demonstration, thanks a lot!
No problem! Thanks for watching!
Hi MitchelSQL. First of all, awesome webinar/ video. Second, I simply love the way you teach and explain things. When I had the premium account at Pragmatic, your videos about DAX are amazing. Now I want to ask you and Pragmatic team starting using zoom in / out when showing something special or when something is in explanation focus mode. Why? Because it will help people watching through mobile devices. I know it will bring you more work, but I almost gave up watching because through mobile it is hard to see measures in detail. Maybe if your audience has to stop mobile and jump to desk or notebook, they could not come back and direct to another video. :) Thanks in advance.
Hi MitchelSQL, would be possible to add a link to download the pbix file used for this demo?
Terrific video!!
Thanks!
Nick, we are glad 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: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg
I don't understand how the SUMX(Values(‘Date’[Month), Dynamic Measure works. . On a base level I get the idea but how PowerBI knows how to do it confuses me.
I get that Values() returns a single column table of the values of each month. Easy. But when the Dynamic Measure runs how does it know that the list of months in the Values(‘Date’[Month]) table are dates and not just a table of text strings. When the Value() function executes does it retain all the associated relationships?
I am obviously reading something wrong. In my mind DAX is saying LastSaleDate in the Dynamic Measure would be evaluated on the table Values(‘Date’[Month]), but its just a list of strings. LastSaleDate looks for the max orderdate on the sales table. January isn't a date.
What am I missing?
Hey Tom,
Remember everything works within the existing filter context, therefore the months are still part of the date table and the date table is filtering the sales table through the active relationship, in this case, the order date.
If I were to remove the year from the report, then that would be removed from the filter context and we would see completely different results, this helps to validate that filter context is taking place. I hope this helps a little. If you want you can email me directly. Thanks, Mitchell
Thank you!