Cross-tab table shows duplicates. How to remove duplicates?

[LissieDomingo03]

I have a cross-tab table of terminations, and each employee has duplicates even though all fields are the same.

• I do not have a Time Filter  in the data source to pull all Events (for terminations and hires)

In a Summary table, I am getting the right total (2):

But in a cross-tab table with employee details, I am getting multiple rows for the two employees:

I am using the same measure for both tables:

[SindhuV]

If you are pulling position table in your query, you will have to set the filter on the mdfRecordStatus = N.