DAX - calculate number of ItemNo

[sima_ue031]

Hello, 

I have this situation and I need help. 

I have requirments to get a number of items with % of grand total : 

I have an Items with sales. I need to sort sales per item desc. After that i need to calculate % of grand total. (column F) 
After that I need to get Number of ItemNo by % of grand total. 

I need to count number of ItemNo summing % of grand total ( column F ). When I got forexample 50%, i need to count nubmer of items. Forexample summing % from top and after 20 items I got 50% i need to put in 50 % of grand total number of 20 items. After that I need to sum again from top until 75% of grand total, and now i have maybe 37 items.

How i can calculate this? 

[Greg_Deckler]

@sima_ue031 Probably need a disconnected table and then a measure that incorporates your logic for what to count. Interesting problem given the need for sorting. Would like to take a closer look but would need sample data posted as text or a link to a sample file.