Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rlhim
Helper I
Helper I

A measure that can display a table of people who haven't done the courses

i'm trying to have a table that tells me which people haven't done the courses.

I have 2 tables: one with all of the people and the other with the people who has done the courses.

But i want the table to be able to filter depending of the course

1 table: Personnel

IPName
001Maria
002Manuel
003Rachel
004Stephanie
005George
006Victor
007Benjamin

2 table: Database

IPNameDateCourseStatus
001Maria6-Dec-22Course 1Asigned
001Maria13-Dec-22Course 2Asigned
002Manuel15-Dec-22Course 1Asigned
002Manuel22-Dec-22Course 2Asigned
003Rachel27-Dec-22Course 1Asigned
004Stephanie29-Dec-22Course 2Asigned

I want the result to be so I can filter by course

Course 1. People that need to be assigned

IPName
004Stephanie
005George
006Victor
007Benjamin

Course 2. People that need to be assigned

IPName
003Rachel
005George
006Victor
007Benjamin
1 ACCEPTED SOLUTION
LuizKoller
Resolver I
Resolver I

I usually use a morning for this kind of problem:

 

LuizKoller_0-1686569400016.png

it is important that the filter direction is Single (if not possible, you can try something using CROSSFILTER).

 

LuizKoller_1-1686570002261.png

 

LuizKoller_2-1686570020937.png

 

LuizKoller_3-1686570043582.png

 

LuizKoller_4-1686570061313.png

 

LuizKoller_5-1686570070588.png

 

LuizKoller_6-1686570080915.png

 

 

 

 

View solution in original post

2 REPLIES 2
LuizKoller
Resolver I
Resolver I

I usually use a morning for this kind of problem:

 

LuizKoller_0-1686569400016.png

it is important that the filter direction is Single (if not possible, you can try something using CROSSFILTER).

 

LuizKoller_1-1686570002261.png

 

LuizKoller_2-1686570020937.png

 

LuizKoller_3-1686570043582.png

 

LuizKoller_4-1686570061313.png

 

LuizKoller_5-1686570070588.png

 

LuizKoller_6-1686570080915.png

 

 

 

 

lbendlin
Super User
Super User

You should be able to do this via "show items with no data".  Otherwise, use a disconnected table for the Personnel and then create the necessary measures.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.