Rey Analytics

 By Akash Rajendran Nair Introduction Have you ever wondered if you could display two entirely different calculations in the same visual dynamically by selecting a value in a slicer? Imagine a scenario where you’re building a demographics dashboard for club enrolment. You want to display both Student and Mentor demographic breakdowns within the same visuals, and switch between them effortlessly with a single slicer selection. In this blog, I’ll walk you through exactly how to make that happen in Power BI. We’ll build a dynamic measure using a disconnected table that lets users toggle views, keeping your report streamlined and intuitive. Understanding the Data Model The model is centred around a fact table called Club Membership, which captures each student’s enrolment into various clubs. This table connects to three key dimension tables: Student Details – contains demographic info for each student Mentor Details – holds demographic info for each mentor Clubs – a simple lookup...