Distribution of Values by Cumulative Percentage, Highest to Lowest.

[mattchunghk]

Please Help!
My power BI

I want to make this : 

My code:

Cumulative Percentage = 
// Define variables
VAR SelectedSeason = "58 SS23"
VAR CurrentProductClass = SELECTEDVALUE('Ordered Lines'[Product Class])
VAR CurrentAccountNumber = SELECTEDVALUE('Ordered Lines'[Account Number])
VAR CurrentItemCode = SELECTEDVALUE('Ordered Lines'[Item Code and Colour])

// Calculate the total GBP for the selected product class and account number
VAR TotalGBPbyProductAndAccount =
    CALCULATE(
        SUM('Ordered Lines'[GBP]),
        'Ordered Lines'[Order Season] = SelectedSeason,
        'Ordered Lines'[Product Class] = CurrentProductClass,
        'Ordered Lines'[Account Number] = CurrentAccountNumber
    )

VAR ItemsWithHigherOrEqualTotalGBP =
    FILTER(
        ALLSELECTED('Ordered Lines'[Item Code and Colour]),
        CALCULATE(
            SUM('Ordered Lines'[GBP]),
            'Ordered Lines'[Order Season] = SelectedSeason,
            'Ordered Lines'[Product Class] = CurrentProductClass,
            'Ordered Lines'[Account Number] = CurrentAccountNumber,
            'Ordered Lines'[Item Code and Colour] = EARLIER('Ordered Lines'[Item Code and Colour])
        ) >= CALCULATE(
            SUM('Ordered Lines'[GBP]),
            'Ordered Lines'[Order Season] = SelectedSeason,
            'Ordered Lines'[Product Class] = CurrentProductClass,
            'Ordered Lines'[Account Number] = CurrentAccountNumber,
            'Ordered Lines'[Item Code and Colour] = CurrentItemCode
        )
    )

VAR CumulativeGBPbyItemCode =
    CALCULATE(
        SUM('Ordered Lines'[GBP]),
        'Ordered Lines'[Order Season] = SelectedSeason,
        'Ordered Lines'[Product Class] = CurrentProductClass,
        'Ordered Lines'[Account Number] = CurrentAccountNumber,
        'Ordered Lines'[Item Code and Colour] IN ItemsWithHigherOrEqualTotalGBP,
        ALLSELECTED('Ordered Lines'[Item Code and Colour])
    )

// Return the Cumulative Percentage by dividing Cumulative GBP by Total GBP
RETURN DIVIDE(CumulativeGBPbyItemCode, TotalGBPbyProductAndAccount)

[Anonymous · Accepted solution]

Hi @mattchunghk ,

It is recommended to create a new calculation table like this:

We need [CumulativeGBPbyItemCode] for sort.

Please check the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum