Calculate the sum of the top 80%

[imbrg]

Dear All,

I have the attached list of accounts with the related sales and cost. 

I calculate the GM for each of them

I need to calculate

• The sum of the top GM of account that is making 80% of the total GM. which means I need to order GM by order of importance them make the sum of the top one until I reach 80% of total GM
• I need to know what was the number of acount that was included in this sum to be able to calculate the average GM

can you please support

Regards,

imed

 Example file

[Anonymous]

PBIX file on my OneDrive

Best

Darek

[imbrg]

Thanks Darek for the solutions

May I ask one more thing?

I need to calculate the average of the GM for the accounts that we have included in the calculation of the 80% of GM

can you please support

regards,

Imed

[Anonymous]

Just create a measure: DIVIDE( [Total GM (80% Top Cust)], [Count of Cust (80% Top Cust)]).

Best
Darek

[imbrg]

Hello Darek

The calculation are working fine however when I use the measure with other fields some a dim table it's not working anymore

can you please support

regards

Imed

[imbrg]

I think the utilisation of addcolumns in the measure is the one causing this issue.

thanks you for your support

Regards

imed

[imbrg · Accepted solution]

Thank you very much, it's working fine