Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
Solved! Go to 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)
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 :
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
Oh that might be the case. Here it is:
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.
I swithed the relationship to Both and it worked. Thanks so much.
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)
Yes sorry the measure shoudl indeed be
INT ( ISEMPTY ( Appointments ) )
the INT converts true/false to 1/0.
PBIX available here: Appointments
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |