Displaying Count in a Card not working

[Anonymous]

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 

@edhans 

[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.

[Anonymous]

Here is the dropbox link

https://www.dropbox.com/s/cdglrogv0ufkj86/FTE%20Budgeting%20Test%20file.pbix?dl=0

[v-xuding-msft]

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.

[Anonymous]

No I have not figured this out yet, here is the link

https://www.dropbox.com/s/xvrp8oqw3eeax48/FTE%20Budgeting%20Test%20file.pbix?dl=0

[Anonymous]

Sorry, what formula? (still kind of new to Power BI)

[parry2k]

@Anonymous do you have any visual level filter on table visual?

[Anonymous]

Yes I have these slicers

[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.

[Anonymous]

I have these filters effecting the table if thats what you mean

Position No can never be blank so I dont think that is it

[v-xuding-msft]

Hi @Anonymous ,

Based on the screenshots, I'm still not clear. Can you please share a dummy file and upload it to OneDrive for Business? Then we can test it.

[Anonymous]

Here is a dropbox link

https://www.dropbox.com/s/cdglrogv0ufkj86/FTE%20Budgeting%20Test%20file.pbix?dl=0

[parry2k]

@Anonymous where you put operation is not blank and vice president is not blank(), where you added that filter?

[Anonymous]

Not sure I 100% understand the question

Is this what you were wanting

[parry2k]

@Anonymous where you put this filter conditions, it is from the screen you shared earlier