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 all
I have the following table result
As seen the first row doesn't show the cumulative percentage, and the 4th row in the cumulative column is not summing correctly.
The DAX I have is:
Pareto UC Cumulative =
VAR TotalUC = CALCULATE([Volume],ALLSELECTED('Ship From'))
VAR CurrentUC = [Volume]
VAR SummarizedTable =
SUMMARIZE(
ALLSELECTED('Ship From'),
'Ship From'[Bottler Owner],
"Volume", [Volume])
VAR CumSum =
SUMX(
FILTER(SummarizedTable,[Volume]>=CurrentUC),
[Volume]
)
Return
DIVIDE(CumSum,TotalUC)
Any idea what could be wrong?
Thanks.
Here is the table:
Bottler Owner | Volume | Pareto UC Cumulative | Pareto UC |
1 | 480,600,034.00 | 37.01% | |
2 | 378,390,784.00 | 66.14% | 29.14% |
3 | 216,308,340.00 | 82.80% | 16.66% |
4 | 101,168,972.00 | 82.80% | 7.79% |
5 | 44,268,330.00 | 94.00% | 3.41% |
6 | 29,624,323.00 | 96.28% | 2.28% |
7 | 29,249,209.00 | 98.53% | 2.25% |
8 | 17,656,202.00 | 99.89% | 1.36% |
9 | 1,429,489.00 | 100.00% | 0.11% |
10 | 100.00% |
Solved! Go to Solution.
Hi,
I tried to create a sample data for myself and then create measures on it, the result is below :
-----------------------------------
Hi,
I tried to create a sample data for myself and then create measures on it, the result is below :
-----------------------------------
Hi,
Share the link from where i can download your PBI file.
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |