Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have the following table below which has the results of a simulation for multiple clients. In the example below, there are 3 clients (A, B and C) and the outcome of 4 simulations that were run for each client.
Client | Output |
A | 9197 |
A | 2816 |
A | 3359 |
A | 1923 |
B | 7128 |
B | 6974 |
B | 6341 |
B | 2994 |
C | 8437 |
C | 9052 |
C | 3412 |
C | 13 |
I also have a slider whereby the user can input a percentile value. I then need to calculate what is the Output value at that percentile for each client and sum it to show the Total.
For example, if the user selects the 25th percentile, then:
Total = 25th Percentile Value for Client A + 25th Percentile Value for Client B + 25th Percentile Value for Client C
Total = 1923 + 2994 + 13
Total = 4930
Another example, if the user selects the 80th percentile, then:
Total = 80th Percentile Value for Client A + 80th Percentile Value for Client B + 80th Percentile Value for Client C
Total = 9197 + 7128 + 9052
Total = 25377
The measure needs to calculate the total dynamically based on a percentile input.
Would appreciate any help on this!
Solved! Go to Solution.
This did the trick:
vClientPercentileInput = 0.25
Total = SUMX( SUMMARIZE(Table, Table[Client], "Total", PERCENTILE.INC(Table[Output], vClientPercentileInput)), [Total])
This did the trick:
vClientPercentileInput = 0.25
Total = SUMX( SUMMARIZE(Table, Table[Client], "Total", PERCENTILE.INC(Table[Output], vClientPercentileInput)), [Total])
@bheepatel , Not very clear. Refer if these links 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
https://finance-bi.com/power-bi-pareto-analysis/
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |