Fixing Relationships with DAX with Stephen Zielke

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

Music: https://www.bensound.com

Join the Community

Become a member of the Calgary Power Platform User Group Community site and never miss a meeting!

View more from the Calgary Power Platform User Group

power bi premium
power bi premium

Share this post

Let's get started with a consultation

Get started with training