Filtering Matrix on values from multiple columns

[BIAB]

Hello everyone

I'm trying to create a fitler that will filter if a specific persons names in in more than on column (EE Name or MD Name).  The issue I'm seeying is that the total I'm getting when I put a filter is Not correct for that Name I filtered.  For example when I filter on Nate I get a total of 41666.66 for transaction 23864 but it shoulb be 20833.33.  I have been looking at this for a couple of days and can't figure out what I'm doing wrong.  Any help is appreciated, see demo file.

Click here to donwload demo pbix

[BIAB · Accepted solution]

It's like magic.  No matter how many days I spend on a problem I can't fix once I post it here I realize hat the issue was LOL.  Adding a relationship seems to fix the problem but if there are any other approaches someone wants to share they are welcome.