TOP 80% of clients by profit

[Anonymous]

Hello PowerBi Community,

I am a beginner and encountered a major problem while making my report. I want to show a bar chart of clients that account for 80% of my profit and the rest by list but I cannot wrap my head around formulas that I could use to make this happen.

I have a table with 6 columns: client, invoice number, date, quantity, sales price and cost to manufacture (profit is a measure: quantity*sales price-quantity*cost to manufacture). Do I have to make some kind of table inside power bi to rank the clients? Because I have no access to editing or creating tables in an original excel file.

Thanks in advance,

Zenons

[amitchandak · Accepted solution]

@Anonymous , refer if these can help

Top 80/20 , percent /percentile
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156

[Anonymous]

Thank you very much, that last link solved my issue!