Filtering Table report

[Shiva_M]

Hi all, when I filter the Table in report view I am seeing 18 items but only 11 rows are showing up. I checked and I have no other filter on. I even checked the Table view and applied the same filtering and I am seeing the 18 rows. Why am I not seeing the same number of rows in the Table as in the filter? hope you can help thanks.

[rajendraongole1 · Accepted solution]

Hi @Shiva_M  - can you add your unique ID / primary key column to the table visual, if row count jumps to 18, grouping is confirmed as the cause., then click on an empty area of the canvas to clear any cross-filter selections, then recheck your row count. use dont summarize on the column that you are placed in fields .

Hope this helps. 

[v-tejrama · Accepted solution]

Hi @Shiva_M ,

Thank you @Mauro89  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.

[rajendraongole1 · Accepted solution]

Hi @Shiva_M  - can you add your unique ID / primary key column to the table visual, if row count jumps to 18, grouping is confirmed as the cause., then click on an empty area of the canvas to clear any cross-filter selections, then recheck your row count. use dont summarize on the column that you are placed in fields .

Hope this helps. 

[Shiva_M]

Hi @rajendraongole1 yes i have realised that it has nothing to do with filters on the table or the page instead I have that I need to have a column in the source file with a unique value filled in each cell. The rows I was not seeing was because the rows contained same data and a lot of missing data as well.

[Mauro89]

Hi @Shiva_M, 

if the data in the table only contains a subset of the whole number of columns in your actual table view, the table might show less because of duplicate values.

E.g. table view:

first name	last name	birthdate
max	mustermann	01.01.2000
max	mustermann	02.02.2020

If you then only take the columns "first name" and "last name" in your table it will show 1 row, not 2.

first name	last name
max	mustermann

Hope this helps!?

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution