Incorrect count in visual

[Anonymous]

Hi all,

I have an Excel sheet with a column filled with -99, 1 and 0. These are the results of an survey

1 = yes

0 = no

-99 is not filled in

I want all the 1's of 3 questions (3 columns), here's and example:

For example in this column I have 88 1's, but when I create a visual I only get 73 1's..

I use the same column in the legend and in values. In values I used the option "total of"..

Can anyone tell me why the count differs from the actual data?

[v-yiruan-msft]

Hi @Anonymous ,

Did you apply any filter, slicer or RLS in the report? What's type of field V15_A1? Is it a numeric type? Which field or measure be applied on Pie chart?

Best Regards

[Anonymous · Accepted solution]

Really weird, I imported the data again and now I get the correct counts.. Not sure what caused this issue.. Sorry, thanks for your help!

[themistoklis]

@Anonymous 

What is the dax formula tha you use?

Or  you use a field and then you specify the calculation type.. e.g. sum?

[Anonymous]

Weird issue.. I tried everything and at last I imported the data again and it worked.. Not sure what caused this issue.. Thanks for your help tho!

[v-yiruan-msft]

Hi @Anonymous ,

This is indeed a very strange problem, not sure if it is caused by caching or other reason... Anyway, it's glad to hear that your problem was solved. And thanks for sharing the solution here. Could you please mark your post as Answered? It will help others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards