Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi All,
I used a Quick measure to find running Sales total for the below table.
I would like to find Weeks when running Sales total was 25%, 50% and 75% of the Total Sales (5 835). I don't wish to manually add a calculated column to the above table.
Is there a solution besides adding a calculated column to my problem?
Thanks
@Tsepo , Are you looking for somthing like 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
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
15 | |
14 | |
11 | |
10 |