FIlter table by profit and number of devs

[hylosko]

I want to filter my table by profit desc and show only values where total sum of dev_num = 30. I mean to show only 30 devs sorted by highest profit every time. if it will be more than 30 devs, calculated table shouldnt show other devs groups.

In table it will looks like this:

DEV_NUM  |    PROFIT

10                   1000000

10                       40000

5                           3000

5                           2000

That i should get from my whole table, as you can see total number of dev is always 30,  and profit is always sorted desc by highest value.

My table looks like:

Any ideas how i can build my measure for calculated table ?

[amitchandak]

@hylosko , Not very clear, Why a measure like sum(Table[PROFIT]) can work

[hylosko]

idk, but i just want to make calculated table based on my main table with that filters which is descripted upper.

it is really hard tu explain but i will try:

this is my main table: 

And i want get sth like this : 

[Anonymous]

Hi @hylosko ，

Do you want to get the related project info which the PROFIT value (sorted from highest to lowest), where the DEV_NUM summary does not exceed 30 ?PROFIT is a simple summary value group by PROJECT_NAME? Or is there some special calculation rule? In order to provide you with a suitable solution, could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards