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

Share on linkedin
Share on twitter
Share on facebook
Share on email

Leave a Reply

Your email address will not be published. Required fields are marked *

Latest Posts

Hot Topics

Stay Up to Date with Our Latest Blogs

Subscribe to our mailing list to be notified when a new blog is released.

Let's get started with a consultation

get started with training