Forum Discussion
Creating a visual to show gap analysis
Here are is what I would do, but not sure if it will work for your data set.
Create a Cross Join Table from Table 1 & 2. (I renamed them Student and Event). This will give you a table with all possible combinations.
Then I created a concatenate formula in that table as well as Table 3 (which I renamed to Log) for Student and Event. Then created a relationship between the 2. Then used the Event and Student Tables as slicers.
Here is the PBIX for what I did. LMK if that works for you.
Student Events Problem PBIX
Thanks for the challenge. I learned something new myself.
Happy to help.
Hi there, I have now found an additional challenge and hope that someone can assist me please?
The above solution works perfectly provided there is a One to One relationship between the Log database and the Crossjoin table because you can add a Page level filter of Blank. If the relationship is changed to Many to One, the Page level filter of Blank disappears and it is no longer possible to view the 14 entries with a Blank 'Concatenate - log' field.