Show items filtered out by slicer

[ZachRoberts]

Hello,

I am trying to display users that are enrolled and not enrolled in specific courses. 

Using a slicer we can select the course we want to view and the user table is then filtered to display all of the users that are enrolled in the course, how can I still display the users that aren't enrolled in that course? 

Selecting show items with no data doesn't seem to work for this?

Thanks

[Anonymous]

Hi @ZachRoberts ,

Can you provide me some samples of dummy data? Then give the corresponding expected results.

Best Regards,

Stephen Tao

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

[amitchandak]

@ZachRoberts , for that you need separate user and course dimensions.

Assume your table has user and course deatils (enrolled), join them with these dimesions

Then create a measure like

if(isblank(countrows(Fact)) , 1, blank())

And plot this against User and course from dimensions 

Create new dimension 

USer = distinct(Fact[User])