I have a table with Vendors and each vendor can provide 1 or more services.
I have property that has two service requests
The desired result for the appliance repair,demo request I should see Demo Only and Projecct to select from.
The desired result for cabinetry request, I should see Great Developers and Demo Only.
I’m using the following expression, but it only works for 1 service request. I want it to find all the vendors based on all the service requests and only show those (like if the request is appliance repair and demo).
SELECT(Vendors[ID],IN([_THISROW].[Services],[Services Provided]))
Your table structure and the column names is not exactly clear but for starters , you may try an expression of
SELECT(Vendors[ID], ISNOTBLANK( INTERSECT([_THISROW].[Services], [Services Provided])))
2 Likes
Thank you, this is exactly what I needed. I tried using INTERSECT() but couldn’t make it work for whatever reason. Can you elaborate on your ISNOTBLANK() usage? Is it simply, only displaying the items that matched commonly and omitting any others that are not “unmatched”?
1 Like
You are welcome.
INTERSECT() will select commom elements between two lists.
So if there is even a single common element between two lists, it means that Vendor Id has at least one service which is desired by the service request.
ISNOTBLSNK() returns true if the INTERSECT() function returns at least one element. Thus the corresponding vendor ID is selected in the SELET() expression.
Hope I could explain.
4 Likes
Your explanation really does help. Thank you for elaborating!
3 Likes
