Evaluation Context - (1.8) Ultimate Beginners Guide to DAX 2019

Learn the importance of evaluation context and follow along to the Beginners' Guide to DAX tutorials by using the demo data available for download. Enjoy!

***** Video Details *****
1:10 calculating total quantity sold
2:31 defining filter propagation
3:17 writing advanced DAX formula

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

***** Related Links *****

***** Related Course Modules *****

***** Related Support Forum Posts *****

[EnterpriseDNA]

Related Links

Related Course Modules

Related Support Forum Posts

[rachitluthra]

Thanks for this video.. made context clear :)

[paultoyle]

Can you tell me how to use in operator in case you have multiple item you want to filter

[rafaelknuth]

In one of your previous lessons, you were getting two different sum of sales results, and you said you would explain that in this lesson. Can you explain briefly why those two results differ? It's easier to understand evaluation context based on an error than on correct data. Thanks!

[karlbambury]

Good evening, I’m experiencing an issue with the Customer name as the context. I’m trying to display the count of store visits by each Customer (unique customer table linked 1-2-many to a store visit table by CustomerID) in a bar chart. However, there are many customers with the same name (but different CustomerID values) and the store visits are being aggregated at this distinct customer name value rather than by each actual customer. The aim is to order the chart by the customers who have visited the most. I’m using a simple COUNT of the CustomerID field on the store visit table. I’ve thought of creating a new field that is the customer name concatenated with the CustomerID but would rather not as it doesn’t appear to be the most refined solution. Any help would be appreciated.

[yiubili]

strange, no subtitle available for this clips...