Calculating Percentile Score for various categories for different companies

[amitchandak]

@91asma2 , either you should add a filter in summarize or create a measure without that company. Or remove in percentile function.  dependent or where the company is available for the filter.

Also refer these

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/

[91asma2]

Thanks @amitchandak  for the quick response. 
not sure where to add the filter. But my issue here is that I still dont get the cualculation right. Any help with to find the percentile?

What I am trying to get to is to find the percentile for each activity category and have two silcers one for the activity category and one for the companies and go from there. 

Thank you