How can I highlight matches/differences in two tables from the same data source with filter applied?

[NAPC8]

Hi All, 

I have little to no experience with PowerBI/Query and DAX and wonder if its possible to compare two tables in power BI and highlight any that appear on both when a filter is applied. 

 I need to audit and check against our segregation of duties matrix on HR core roles to see which staff member has access to any mix of roles that need to be flagged as a conflict. 

I have 2 tables both pulled from the same data sheet both of which can be filtered by the core roles to then compare the list of staff. Instead of scrolling through all is it possible to highlight. 

i hope this makes sense....

users attached to Role PY Specialist shown in Table B check if they appear in Table A against HR ADIM role 

Thanks 

Niall

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.