How to display 20 rows of a visual table

[User12345432334]

I have a table with 3 columns: technologies, summary and count where i display the total number of each summary split by technologies. Right now it displays them in order, which is good:

Now I want to display only the first 20 rows. When I go to filters panel and i select top N for summary and the value is the count column, it displays 22 instead of 20 and the values are not in the correct order:

After value 245 I should have 231, instead I get 199 and the order is not right. What can be the issue?

[Anonymous · Accepted solution]

Hi @User12345432334 

@audreygerred Thank you very much for your prompt reply and here allow me to share some of it.

When applying the first N filters, make sure you select the correct field for the filter. It should be set to filter the Summary column based on the Count value.

If there are duplicate values in the Count column, the first N filters may contain more rows than expected.

Ensure that no other filters or slicers affect the visual object. Other filters may affect the data displayed.

If these steps do not solve the problem, you may want to consider create a measure, for example:

rank count = RANKX(ALL('Table'), CALCULATE(SUM('Table'[count])),, DESC, Dense)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[audreygerred]

Can you send screenshots of all filters for bothe scenarios (topN and not topN)?