Filter Table of Images to only show ones that are associated with record in other table (slicer)

[JWGlom]

Essentially, I have a PowerApp being used for auditing. All data is stored in SharePoint Lists. The solution is comprised of several different lists that are linked via SharePoint generated IDs. When an audit is completed, I am automatically creating "issues" which have associated images. These images are stored in a Document Library. I am storing a comma seperate text field in the issue log entry of associated images ids. So in my app, I am easily able to grab all images in the Document Library that have an ID that is stored in this comma seperated text field. So that is all good... the challenge is in PowerBI. 

I have created a "dashboard" to show audit results and I have a screen to show associated issues found from the audit. I want to show the images of the selected issue but all I am able to do is show all images that match that audit Id. I cant figure out the proper method or syntax to create a measure or what not to filter the resulting images to only those that are contained in the comma seperate text field of the issue log entry. As a first attempt, I duplicated my 'Audit Issue Log' table and split the column into rows so each attachment id is in a seperate record. I then created the below relationships. 

This image shows the relationship between the tables.

Yes when I select an issue from my slicer, I still get all images returned:

Where as in the app you can see this is all that should show:

Thank you!

[hnguy71 · Accepted solution]

Hi @JWGlom 
Seems your issue is relating to an invalid relationship. A combination of the "Facility", "Issue", and "Image" fields are at play. Your "Issue" field and "Image" field seems to be coming from at least two different tables. You may want to check the direction of the relationship going from one table to the next.

Can you upload your sample? It may be easier to help debug and diagnose the issue. 

[JWGlom]

Appreciate the help! I changed the direction to both and removed "Facility" from the slicer. That fixed it right up: