Forum Discussion
Creating a calculated Benchmark within a dashboard
Hi all,
I am trying to create a benchmark of % of spend for certain good types with Low Cost vs High cost countries such that I can filter my data set and see how much importer A currently imports from Low Cost Countries (and which) vs the benchmark of imports from low cost countries (and which)
I have a confidential data set that contains all of this information. I now just need to calculate the benchmark for low cost countries but I want it to be dynamic such that it always takes the 20th percentile as the benchmark. (i.e. if I filter for good A the 20th percentile benchmark may be 5% but if I filter for good B the 20th percentile benchmark may be 40%).
I hope that made sense.
Thanks,
Lucas
1 Reply
- amitchandakSuper User
Anonymous , refer if these can help
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
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.