Forum Discussion
Solved
Count function is doubling
Hi I have a card visual. The count function is doubling everything. Both via a measure and via the "aggregation" option where you choose sum, average, count etc. I've checked the table. ...
Hi
Apologies, my dataset had duplicate values under a different file source name - I was filtering on file source assuming they were the only ones containing the data I was analysing - there were other files that had the exact same data. Just another by-product of having to work around your IT team, rather than with them.
danextian
Super User
Super UserIn the table view, does it also show only 481 rows? Adding fields to a table visual can remove duplicate rows, so it’s not always a direct comparison of the actual row count in the dataset. The COUNT function counts all rows in a column regardless of duplicates—try using DISTINCTCOUNT instead. If the issue persists, consider sharing a non-confidential copy of the PBIX file.