Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |