Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
@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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |