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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
PWSNEALE
Frequent Visitor

Show Data from table that has no relationship to another table

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

1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

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)



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

8 REPLIES 8
Jodes007
Frequent Visitor

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

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



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Oh that might be the case. Here it is:App Usage PBI.png

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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

PWSNEALE
Frequent Visitor

@bcdobbs ,

 

Thank you! that worked excellent!

bcdobbs
Super User
Super User

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)



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Yes sorry the measure shoudl indeed be

 

INT ( ISEMPTY ( Appointments ) )

 

the INT converts true/false to 1/0. 

 

bcdobbs_0-1639159116609.png

bcdobbs_1-1639159141843.png

 

bcdobbs_2-1639159178160.png

 

PBIX available here: Appointments 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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