cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rlhim
Frequent Visitor

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors