Total count does not match raw data (simple data set)

[lissiedomingo03]

This is my simple data set. 

Position Code - is filtered to only show "Key Positions"

Readiness - is filtered to only show "1-2 years"

A Nominee Employee ID may have duplicates, which is OK. A Nominee Employee ID may also be tied to a Position Code that is not a Key Position, which is why I have the Key Position filter.

When I extract the table, the total number of rows is 73. But in the first two boxes, it shows 78. There are 5 Nominee Employee IDs tied to a Position Code that is not a Key Position. Even if I have all filters applied, it still shows 78. What am I missing here? I hope someone can help; I'm a newbie.

[Anonymous · Accepted solution]

Hi @lissiedomingo03 ,

There are a number of scenarios that can lead to this problem, one of which is the presence of duplicate rows in a table. When displayed in table visual, these duplicate rows are merged by default.

If the problem persists, it may be necessary to share a sample of your dataset or the exact steps for applying filters and extracting data. This way, I can provide more specific instructions.

Best Regards,
Adamk Kong

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

[parry2k]

@lissiedomingo03 very hard to tell, It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.