Forum Discussion
Displaying Count in a Card not working
Hi All,
I am trying to display the count of positions in the table but the number is showing 19, but you can see there are clearly only 16 in the data set. Am I missing something?
Thanks
15 Replies
- parry2k
Super User
Anonymous do you have any visual level filter on table visual?
- parry2k
Anonymous I assume the count of position no in the card is from the table as matrix visual? Slicers are ok but do you have a visual level filter on a matrix that will not propagate to card visual. Can you confirm that? Also, do you have any measure in the matrix visual? if there is are measures in the table visual and return blanks(), those rows will not show in Table visual but will get counted in Card visual. In nutshell, there can be many factors.
- amitchandak
Anonymous , can you share the formula. Just check you are not counting when values are 1 and 0. In that case, it should be a sum.
Here is the dropbox link
https://www.dropbox.com/s/cdglrogv0ufkj86/FTE%20Budgeting%20Test%20file.pbix?dl=0
v-xuding-msftCommunity Support
Hi Anonymous ,
Sorry for late back. I find that the sample link is not working. Have you resolved the problem? If yes, can you please share the solution? More people will benefit from this thread. If you still need help, please share the sample again.
I assume the count of position no in the card is from the table as matrix visual? Slicers are ok but do you have a visual level filter on a matrix that will not propagate to card visual. Can you confirm that? Also, do you have any measure in the matrix visual? if there is are measures in the table visual and return blanks(), those rows will not show in Table visual but will get counted in Card visual. In nutshell, there can be many factors.
