Why the total count shown is different than the count in the exported table?

[Anonymous]

Hello

I have a table visual with data and all the fields have selected 'dont summarise' and 'show items with no data'.

The table has 53 rows and the exported table also has 53 rows plus one which is the header.

However, I have a card visual which is comprised of the same first field of the table visual and the 'count' is selected (not distinct count). This visual shows 55!

When I select individual rows from the table, the card visual correctly updates the count, 1, 2, 3 etc.

But the total count is wrong, do you have any idea?

Thanks! 

[v-lili6-msft]

hi @Anonymous 

What is the total count? if it is the total in current table visual, that will always keep the same.

If not your case, could you please share some screenshot or use simple virtual data to create a pbix file for us have a test? that will be a great help.

Regards,

Lin

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Unfortunately it's all very sensitive and I would be in trouble if I share. Removing and changing the data might remove the problem too.

Are there any ideas for troubleshooting?