Help with filtering first 10 records in table

[nitrox]

Hi everyone,

I am trying to apply a filter on a table and I can't find the solution 😞

I have the following table and I need to filter the first 10 records taking into account the column "type".

Based on the attached table, it should show me the first 10 "A" records. If there are few A's, it should show the B's, C's...etc....

Many thanks

[PaulDBrown]

@nitrox 

Let me kindly ask you to refrain from duplicating threads. It disperses answers and is not helpful for other people seeking to solve similar problems. 
As regards your question, you can add the measure to the visual in the filter pane and filter the values you need to display by using "is less than" and type in 11

[Anonymous]

You can use the Top N feature in filter pane and get the top 10 results as shown below:

Kindly mark this post as solution and give kudo if it helped

[nitrox]

Hi @Anonymous. Yes. I have tried filtering the values using the filtering panel but it does not work. Attached is a screenshot of how I have configured it.

[Anonymous]

This is happening because your column unidades has duplicate values. I suggest you to create an Id column and then apply the Top/Bottom N filter. It works for me as shown below:

[nitrox]

Hi @Anonymous. 

In the end I was able to solve it by doing the following.

1. I defined the sorting in the table by the column type
2. I created a new column called index
3. Then I created an auto numeric measure based on the records shown in the table (in case there are filters).

RowNum = CALCULATE (COUNT( Hoja1[Índice] ), FILTER ( ALLSELECTED ( Hoja1 ), Hoja1[Índice] <= MAX ( Hoja1[Índice])))

4. With the new measure I have filtered to show me the first 10 records.

With these changes, I have managed to filter the first 10 records taking into account the column type

The problem I have now is that if I do not add the "Index" column, the system does not apply correctly the sorting by rownum column.