Filters Pane Not Showing Count

[Anonymous]

Hi

I'm having a problem in that the filters pane is not showing a count of values - I'm not sure how I've managed to do it or how to revert to its pervious state, hopefully it something simple! 

In a nutshell, I have two PBI books. Each one contains an identical dimension pulled from a table in a SQL database. When I pull a value from the dimension into the filters pane however, one of the book returns counts against the dimension value, the other does not. The following screenshots give an example of what I mean:

Book One Returns the following:

Book Two Returns the following:

I've gone through the settings on each book and as far as I can see they are identical (I've tweaked a few things to align book one to be the same as book two but the changes have not made any difference).

Does anyone know why the above might be happening?

Thanks

Nick 

[v-easonf-msft]

Hi， @Anonymous 

This is really strange,I have never encountered a  similar situation.

User cannot turn the count off by default. A related idea has be listed here.

https://ideas.powerbi.com/ideas/idea/?ideaid=4424214b-0fd2-4743-a34c-f05d9456529c&page=1 

If you still have no idea about your problem, you can open a support ticket with MSFT to seek technical support , usually they will have better suggestions.
https://powerbi.microsoft.com/en-us/support/ 

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi Eason

I get where you're coming from, but unfortunately that's not the case either - they are literally the same sets of data, coming from the same table in the database, so the row counts on them are identical.

Given no one's able to give me any answer - and the only questions I can find about this relate to REMOVING the row count (which no one has an answer for either), I can only assume that my book has corrupted somehow and its not returning the row count because of that.

If that is a case, that is a pain because it would be a huge amount of work to rebuild the book.... I'll leave this open and hopefully someone can tell me I'm doing something stupid!

Thanks

Nick

[v-easonf-msft]

Hi, @Anonymous 

I guess the number of rows in the  book one is more than 1 million while the second book does not.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi @amitchandak 

Thanks for the response - unfortunately that it doesn't perform a count either way though.

To make the question as as simple as possible, actions performed are as follows:

1) I open both models at the same time, find in the field in the dimension and click on it.

2) As I'm sure you know, PBI then automatically dumps the text field into a table visual

3) I then go to the filter pane on the right and look at it:

    - book one does not show any counts

    - book two shows the row counts

😞

[amitchandak]

@Anonymous , this is what I observed. When it come(count) because it added to visual it does not show count. But when you add it to filter pane. It shows count