DAX: Active vs. Inactive Relationships in Power BI @chandoo_
DAX: Active vs. Inactive Relationships in Power BI  @chandoo_
Uploaded May 2025 | Updated November 2026, 3 hours ago
Set up more than one relationship between tables in Power BI Data Model. Learn how to work with USERELATIONSHIP() function in DAX to manage active vs. inactive relationships between tables.
Also learn how to visualize data from both tables in matrix and "new" card visuals with powerful story-telling tricks.

πŸ’₯ Sample file (demo): app.powerbi.com/view?r=eyJrIjoiODY2N2RiYzUtZjYzNy00OTVmLTgxZDctNjQ0NTA5ZDQxYWYyIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9

πŸ“ Raw data: github.com/chandoo-org/Power-BI/blob/bc089ea4514d84221fd174a564fd7156177dbc43/insurance_dashboard/motor_data14-2018.zip

πŸ”’Complete workbook: Available in my online Power BI class

πŸ§‘β€πŸ’» Join my Power BI Class (get $100 / $50 discount): Visit chandoo.org/wp/power-bi-course to sign up for my complete, step-by-step Power BI course. Use coupon code SAVE100 to get $100 or Rs 6,000 discount on the course fees.

πŸ• Video timestamps:

0:00 - More than one relationship between tables (how they look)
0:45 - About the dataset (insurance policy data)
3:10 - The relationships between tables - active vs. inactive
4:03 - Creating DAX measures to analyze data
5:52 - USERELATIONSHIP DAX function
8:58 - Matrix visual with net policy gain trends
13:45 - You are going to LOVE 😍 this
14:48 - "NEW" Card Visuals and showing Individual Year Values
18:55 - Reference Labels & Conditional Formatting
21:10 - Dynamic Card Titles
22:30 - Formatting the cards
24:28 - Custom interactions


~

#powerbi #datavisualization #dashboards
DAX: Active vs. Inactive Relationships in Power BIHow to ACTUALLY use AI + PYTHON to Analyze Data (real-time example)Learn Power BI Service in Just 15 MinutesTop 10 Excel Functions for Data CleaningHow to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File)I got braces in my 40s!Excel SUBTOTAL Magic πŸͺ„Learn Data Modelling & Star Schema for Power BI in 20 minutesHR Data Analytics & Awesome Dashboard with Power BI πŸ’‘: End-to-End ProjectPower BI got a MAJOR upgrade - This changes everything!How to pick the perfect chart for your situation in Power BI?WRAPROWS in Excel - a must have function
Chandoo |

DAX: Active vs. Inactive Relationships in Power BI

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER