Fixing Relationships with DAX with Stephen Zielke

power bi premium

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:

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!

View more from the Calgary Power Platform User Group

power bi premium
power bi premium

Leave a Reply

Your email address will not be published.

Renata Kalsbeek is a Marketing Coordinator of Iteration Insights, a tech-enabled, data analytics solutions provider located here in Calgary, Alberta. Renata graduated from Ryerson University with a Bachelor of Commerce, where she completed a double major in Marketing and Economics within 3 years. She is passionate about marketing strategy and planning and has developed an interest in leveraging marketing automation to run a lean marketing team. Outside of work, Renata loves rock climbing and exploring the beautiful scenery of Banff National Park. With a drive to climb to the top of any mountain, she brings the same mentality to her work; striving to master all avenues of marketing.

Iterate With Us

Signup for the Iteration Insights newsletter for access to recent news and other updates.

Related Posts

Share on

Next Event

Sign up for our newsletter