Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |