Missing total distinguished count

Of course, I thank you for your support.

I explain:

I did the job first in the Excel sheet (Example) that file has approximately 29,936 records with duplicates, when I removed the duplicates I noticed that some cells were left with the value Empty Cod in the final columns, I deleted them manually.

The archvio that you will see as semesters in sheets, on each sheet are the separate records in semesters, the union of the records of those 3 semesters: 2020-S1,2020-S2 and 2021-1 in total are 17,321 without duplicates, with that value is that you must work.

I created a new file(Dataset) this is the one that ran out of duplicates 17,321 of the initial 29,936, when filtering in Excel the latter file the summations match.

Here's what the solution should look like:

5399+6565+5357= 17.321

I created a new PBIX file (I named it Dashboard), a sheet with duplicates(29,936) and another sheet without duplicates(17,321) that comes from the DATSET font already filtered and joined with the records of the 3 semesters., when I added the slicer with year and semester to that new sheet, the summations match the total(goal).

conclusion:

In Power Bi when applying the distinctive count measure in the display field cod, or when removing duplicates from table editing, the value it throws from distinctive counting is approximately 14,000, about 3,321 records are lost so it does not work with the first sheet, it should be noted that if the separation is done by semesters and joined as I did in the DATASET(17.321) file everything is added correctly and the target is met.

File download: https://github.com/orlapez/API