Filter page by top 10 occurrences of values in text field

[HadasSpier]

Hi everyone,

I want to filter the page in my Power B.I report by the 15 entries that appear most in a text field.

For Example:

Category	Technology	Vendor
Hadas	something	a
Livne	something	b
Hadas	something	a
Rotem	something	a
Hadas	something	c
Livne	something	a
Rotem	something	b
Rotem	something	c
Livne	something	a

In this example, if I wanted the top 2 vendors, I want to see only the rows that the vendor value is a or b.

Thank you!

[v-henryk-mstf · Accepted solution]

Hi @HadasSpier ,

According to your needs, I did the following test and created two columns, one to mark the rows of a and b, and the other to count the number of their corresponding rows. Then put the col_count field in the Filter to filter the top 2 suppliers through TopN and display the corresponding rows, and the expected results are as follows:

Column = IF('Table'[Vendor] IN {"a","b"} ,1,blank())

Col_count =
CALCULATE (
    COUNT ( 'Table'[Column] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Vendor] = EARLIER ( 'Table'[Vendor] ) )
)

Here is the sample pbix file.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[HadasSpier]

I succeeded,

Thank you!!!

[amitchandak]

@HadasSpier , You can filter TOPN at the page level (TOPN on using a measure). It can be done at a visual level or a measure can be created

https://www.youtube.com/watch?v=QIVEFp-QiOk

[HadasSpier]

Hi Amit,

This example shows TOPN on a number type data field.

I need the top 15 values that appear the most times in a text data field, without any connection to another column.

I didn't find any example for this situation.

Thank you for your time!