Pareto not working correctly

[o59393]

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%

[MahyarTF · Accepted solution]

Hi,

I tried to create a sample data for myself and then create measures on it, the result is below :

-----------------------------------

Pareto UC Cumulative =

Var Cumulative = IF(

                    min(Sheet99[Bottler Owner]) <= CALCULATE(max(Sheet99[Bottler Owner]), all(Sheet99)),

                    CALCULATE( sum(Sheet99[Volume]),

                            filter(all(Sheet99[Bottler Owner]),

                                    Sheet99[Bottler Owner] <= max((Sheet99[Bottler Owner]))  )

                            )

                    )

VAR CurrentUC = CALCULATE(sum( (Sheet99[Volume]) ))

Var SumAll = CALCULATE( sum(Sheet99[Volume]), all(Sheet99) )

Var Result = divide(Cumulative,SumAll)

Return Result

--------------------------------------------------

Pareto UC =

VAR CurrentUC = CALCULATE(sum( (Sheet99[Volume]) ))

Var SumAll = CALCULATE( sum(Sheet99[Volume]), all(Sheet99) )

Var Result = DIVIDE(CurrentUC, SumAll )

Return Result

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.