This is a great example of how to troubleshoot DAX by going back to the basics of context filtering and walking through the steps of what exactly the function is doing. Even if you never use ALLEXECPT, this is a great video by Alberto Ferrari to demonstrate that principle.
In our BI journey, we all hit a plateau in our learning curve. One reason is that we haven't modeled our solution correctly. In order to move to the next level of our journey along the BI learning curve, we need to understand how a tool like Power BI works. Only then will we understand why we design our data models the way we do. In this session, we will review how tools like Power BI work how that impacts the way we build data models.
About: Michael McKinley is the founder of McKinley Consulting. Michael has managed data transformation projects for the last nine years. He is Microsoft Certified in Power BI and the Power Platform and has worked with major clients such as HCA, FedEx, and the United Methodist Church, among others.
Sometimes, it’s good to return to the fundamentals. If you are connecting a Date table to a fact table, you have to connect columns of data type date. Patrick Leblanc shows you why.
If you’ve ever been curious about the XMLA endpoint, what it is, and what you can do with it, Adam Saxton walks you through all the basics.
I keep getting asked when it is best to solve a problem with data transformation (i.e., Power Query & M) and when it is best to solve a problem with DAX (or proper data modeling). Matt Allington and Ken Puls walk you through which technique to use when.