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
rshifflet
Frequent Visitor

Compare two tables to find missing equipment inspections

I have two tables.

  • Table 1 has a MASTER LIST of equipment numbers.
  • Table 2 has a list of dates the equipment numbers were inspected.

 

I need to be able to use the dates inspected from Table 2 as a slicer to produce a list showing which equipment numbers were inspected, and another list showing which ones were not inspected. 

 

I have tried the following:

  1. Measure subtracting distict values for equipment numbers from both tables - This did not work as once the date slicer was used, the list for not inspected equipment disapears, even with the show blank data turned on. 
  2. Appended both tables to create a new Dimention table. - This did not work for the same reasons as #1. 
  3. Merged both tables, however this did not seam to work for the same reasons as before.

Any help would be greatly appreciated. 

 

1.JPG

2 REPLIES 2
Icey
Community Support
Community Support

Hi @rshifflet ,

 

Is this problem solved?

 

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

If not, please share me a dummy .pbix file, removing sensitive information. It is suggested to upload your file to OneDrive for Business and then paste the link here.

 

 

Best Regards,

Icey

Hennadii
Helper IV
Helper IV

Hi @rshifflet , I had similar issue as you. I found a way which described in my latest post here: https://community.powerbi.com/t5/Desktop/Filter-table-based-on-related-table-with-inactive-relation/...

 

The key point there, is to create an intermediate table which is needed in your case as well. That table should has a column Named like IsInspected. A value for this column should be evaluated (last IF expression in my post).

After that, you can place two instances of the new table and filter content by selecting in a filter different values of IsInspected column.

 

Hope it can helps you

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors