Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have two tables.
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:
Any help would be greatly appreciated.
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
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |