How to calculate Cumulative Sum in Power BI

Question

How can I set cumulative sum for the following dataset

Answer 1

Go to measure New measure<- Total <- Running Total and create:

sales running total in part = 
CALCULATE(
    SUM('Query1'[sales]);
    FILTER(
        ALLSELECTED('Query1'[part]);
        ISONORAFTER('Query1'[part]; MAX('Query1'[part]); DESC)
    )
)

which gives us

 

Check out the Power BI tutorial for more reference

Get an introduction to Power Bi from the below video: 

Looking for a comprehensive Power BI course? Enroll now!