Get Names of companies whose revenue is greater than 100000 and a no. Search input for the companies

[Datagulf]

I have a table with some of the columns as shown below

COMPANY NAME	REVENUE
Company A	56000
Company B	78000
Company C	122000
Company D	367000
Company E	104000
Company F	450000
Company G	34000

SO I want to develop a  measure that will have the companies only with Revenue higher than 100,000. This will then be added to a visual table that should only contain the names of the companies and the Revenue higher than 100000. The catch is, the companies are around  1000 entries and there is a need to have an input filter where if I input 10, it ranks only the highest companies with a revenue of 100,000. Please assist. Thanks

[amitchandak · Accepted solution]

@Datagulf ,

Sumx(filter(summarize(Table, Table[Company], "_1", sum(Table[REVENUE])), [_1] > 100000), [_1])

Plot this with company Name

[Datagulf]

Hey, It works perfectly however, what about a search input where I put 10 and it filters the top 10. is that possible?