Join Stephen Zielke, Ph.D. as he showcases how to use DAX expressions to fix relationships in Power BI.
A well thought out Power BI data model can make creating a well functioning report a breeze.
Relationships form the core of any model, but what if the relationships you have won’t allow the calculations you want? Do you want dimension tables to filter each other? Should a fact table filter a dimension? By getting creative with your DAX measures, it is possible to do this and more, while still keeping the model functional.
This session will introduce and explain several DAX functions for manipulating relationships including CROSSFILTER, USERELATIONSHIP, and TREATAS.
Read Stephen’s Blog: https://iterationinsights.com/article/fixing-relationships-with-dax/
This video was recorded during the Calgary Power Platform User Group on Nov 17, 2020.
Stephen Zielke’s Social Profiles
Join the Community
Become a member of the Calgary Power Platform User Group Community site and never miss a meeting!