Forum Discussion
Filter and Visualize Historical Data Using Slicers
I have 3 tables: A Countries and Groups table that contains a list of countries and the respective Groups they belong to. This table has countries that can have duplicate or triplicate entries due ...
jytech - You will probably want to use the Disconnected Table Trick. Basically, you form a relationship between two disconnected tables using a measure. In this way, you can be very exact with regard to how the tables relate to one another.
Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Here are additional examples:
Greg_Deckler I appreciate your response but I'm not sure how the Disconnected Table Trick will help me. I posted a follow up to my original post which specifies exactly what I need with some images for reference.
