Filtering off a query results. Last step to getting my report working the way we need.

[HLAdata]

Hi, 

I have a report that I need help with. This one is going to be for the big brains. The report pulls in a number of items from different columns and I need to filter anther query (1 column) off it.  Right now as it stands I have done a work around of a slicer seen in the second pic. but you can only put one value in at a time into the slicer which is not ideal with 18 different possible slices. Ideally I would like to select the top table and have it filter all the values at once. The top table does change based on the patient mrn.

Filtered off A*24:02 but would love for it to filter off A*24:02, A*26:01, B*37:01, B*58:02 and so on. 

There is no direct relationship between the tables. 

Thank you in advance for reading my post and attempting to help find a solution.

[Anonymous]

Hi @HLAdata ,

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.