Skip to main content
cancel
Showing results for 
Search instead 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

Reply
harri_soares
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:

 

harri_soares_0-1649636645858.png

*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
Jihwan_Kim
Super User
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.

 

Picture1.png

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.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
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.

 

Picture1.png

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.


Go to My LinkedIn Page


tamerj1
Super User
Super User

@harri_soares 

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

Helpful resources

Announcements
Fabric Community Conference

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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

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