DAX: Active vs. Inactive Relationships in Power BI

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): https://app.powerbi.com/view?r=eyJrIj... 📁 Raw data: https://github.com/chandoo-org/Power-... 🔒Complete workbook: Available in my online Power BI class 🧑‍💻 Join my Power BI Class (get $100 / $50 discount): Visit https://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