Cumulative per customer

Hello Syndicate_Admin, let me try.

To achieve this, you need to create DAX measures that accumulate the M2 Dispatched values per Client and Year, ordered from highest to lowest, and then calculate the cumulative percentage.

Suggested DAX Measures:

TotalM2PerClientYear =
CALCULATE(
    SUM(LoadItems[M2 Dispatched]),
    ALLEXCEPT(LoadItems, LoadItems[Client], LoadItems[Year])
)

Accumulated M2 Dispatched for Pareto

AccumulatedM2Pareto =
VAR CurrentClient = SELECTEDVALUE(LoadItems[Client])
VAR CurrentYear = SELECTEDVALUE(LoadItems[Year])
RETURN
CALCULATE(
    SUM(LoadItems[M2 Dispatched]),
    FILTER(
        ALL(LoadItems),
        LoadItems[Year] = CurrentYear &&
        LoadItems[M2 Dispatched] >= 
            CALCULATE(SUM(LoadItems[M2 Dispatched]), LoadItems[Client] = CurrentClient)
    )
)

Cumulative Percentage

CumulativePercentage =
DIVIDE(
    [AccumulatedM2Pareto],
    CALCULATE(SUM(LoadItems[M2 Dispatched]), ALL(LoadItems), LoadItems[Year] = SELECTEDVALUE(LoadItems[Year]))
)