Total sum for equal values - measure in Power BI

[mniepytalska_]

Hey,

I would like to kindly ask for help on writing a measure that will add line by line a variable called “%”

I have a table in Power BI:

And I need a table with the measure “Total sum” as below:

My problem is to calculate the cumulative sum for values that are the same, maybe it is possible to add the ranking per row, where for 17% will be 1 and 2?
Thank you in advance for your help!

[mniepytalska_]

@Jihwan_Kim Thank you so much! managed to do on my report, on my model :)))

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

One of ways to achieve this is using WINDOW dax function and try order the sequence by percent value descending and by type number ascending at the same time.

WINDOW function (DAX) - DAX | Microsoft Learn

expected result measure: =
CALCULATE (
    [percent %],
    WINDOW (
        1,
        ABS,
        0,
        REL,
        ALL ( data[type] ),
        ORDERBY ( [percent %], DESC, data[type], ASC )
    )
)