cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

New Member

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

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.

1 ACCEPTED SOLUTION
Super User

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
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

2 REPLIES 2
Super User

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
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

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

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors