Calculate the sum of group percentiles based on dynamic percentile

[bheepatel]

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!

[bheepatel · Accepted solution]

This did the trick:

vClientPercentileInput = 0.25

Total = SUMX( SUMMARIZE(Table, Table[Client], "Total", PERCENTILE.INC(Table[Output], vClientPercentileInput)), [Total])

[amitchandak]

@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/