Forum Discussion
Total count does not match raw data (simple data set)
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.
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
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.
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
