Show Data from table that has no relationship to another table

[PWSNEALE]

Hello,  

I am new to PowerBI so please bear with me. I have two tables, Appointments and Visitors. I have a relationship built on a column labeled Pickup Number. I need to show only the data from the Visitors table where the Pickup Number is not on the Appointments table. Esentially showing me who was there without an appointment. Can someone please assist me? 

Thanks in advance

Steve

[Jodes007]

Hello I have a similar set up but this formula is not working as expected with me. 

I have two tables:  Table 1 - HR file, Table 2 - List of Applications with email addresses. 

The comman relationship between the two is email address. 

I needs to see from table 2, which emails are not in table 1. 

I used as suggested : 

NO Org = INT( ISEMPTY('HR File'))

But I get all 0 when I know for sure that 75% of the emails are in the HR file. 

Any help is appreciated. 

Thanks Jodi

[bcdobbs]

Hi,

Can you share a picture of the relationship between the two table. I suspect that Table 1 is filtering Table 2 which will be opposite from above. Once confirmed I'll build a demo and send ba k

[Jodes007]

Oh that might be the case. Here it is:

[bcdobbs]

So you could change the cross filter drop

down so it's the other way round. However that may break other things. I'll mock a different solution up for you.

[Jodes007]

I swithed the relationship to Both and it worked. Thanks so much. 

[PWSNEALE]

@bcdobbs ,

Thank you! that worked excellent!

[bcdobbs · Accepted solution]

You could write a measure like:

No Appointments = ISEMPTY(Appointments)

You can then drops the names from Vistors table into a table visual and use the No appointments measure to filter it.

(You might need the measure to read

INT (ISEMPTY (Appointments)) to use it as a filter set to 1)

[bcdobbs]

Yes sorry the measure shoudl indeed be

INT ( ISEMPTY ( Appointments ) )

the INT converts true/false to 1/0. 

PBIX available here: Appointments