Running Total (Cumulative Percentage) by Categorie : Question from a newbie in PowerBI community!

[harri_soares]

I thougt my problem was simple at first, but I'm still struggling to find an answer for it. Maybe it's because I'm new in PowerBI. Anyway, here's what it is:

*Don't mind the names in Portuguese

I've created a table that shows the total losses and percentual for each different product categorie, now I want to show the percentual running total (cumulative percentual) in a new column at the right side. In Excel, this would be simple, I'd just use the formula SUM($A$1:A1) at the first cell and drag the formula all the way down. But in PowerBI it's different and the only content I've found explaining about this problem relate the filter to date time and don't mention this complex part which I talked about. Please give me a hint.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

Value total: = 
SUM( Data[Value] )

Pareto percentage: =
VAR currentvalue = [Value total:]
VAR runningtotalbyvaluesize =
    SUMX (
        FILTER ( ALL ( Data[Category] ), [Value total:] >= currentvalue ),
        [Value total:]
    )
VAR allvalue =
    CALCULATE ( [Value total:], ALL ( Data ) )
VAR paretopercentage =
    DIVIDE ( runningtotalbyvaluesize, allvalue )
RETURN
    paretopercentage

[tamerj1]

@harri_soares 

To do that, first you have to have an index or id column that represents a unique integer of each [NIVEL2] value. 

[akarmakar]

How do we use the Index/ID column here?