Indirectly filter a table

Hi BenSettle,

I replicated your data set and it's working fine. Take a look.
According of your example the Plan 1 have Course 1 and 2 and the corresponding enrolements are 211,212,213,214,215 and 216 like I have in this picture:

If I choose Plan2 the output must be blank because in our example we don't have any enrolement and as you can see in the picture below is working:

I also attaching my pbix file so you can take a look. If you need any help please let me know.

Hi BenSettle 

Agree with _AAndrade. Your model seems to be fine.

Regarding your concern about filter, I think it's because you don't have enough data in your Table C - enrolments table sample, your table currently only contains course information for Plan 1, so when you select Plan 1 in the slicer, nothing happens to the data in your table visual, and when you select Plan 2 or Plan 3, the table visual returns blank, as the _AAndrade reply to the screenshot shows.

I'm trying create a table of enrolments filtered training plan,  but when I add the filter the data doesn't change.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.