cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jessiew Frequent Visitor
Frequent Visitor

Calculate cumulative percentage from a calculated column

Hi,

I would like to calculate the Cumulative Qty% like it shows in the excel spreadsheet below. I created a measure for the calculation. But the calculation doesn't seem to be accurate. Can someone point me what is wrong with my measure?

Excel calculation.pngPowerBI measure.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

You may refer to my solution in this PBIX file.

 

Hope this helps.

 

Untitled.png

8 REPLIES 8
Highlighted
Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

Please share the download link of the Excel file that you have pasted in the screenshot.

Community Support Team
Community Support Team

Re: Calculate cumulative percentage from a calculated column

Hi @jessiew,

 

I'm not clear about your sample data so I made a test with a sample data similar with yours, but I add an Index column to calculate the cumulative percentage.

 

Measure =
CALCULATE (
    SUM ( 'Table1'[Column] ),
    FILTER ( ALL ( 'Table1' ), 'Table1'[Index] <= MIN ( 'Table1'[Index] ) )
)

Capture.PNG

 

You could have a reference of the formula above.

 

Hope this can help you!

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jessiew Frequent Visitor
Frequent Visitor

Re: Calculate cumulative percentage from a calculated column

Hi,

The excel spreadsheet Sheet 4 indicates the calculation of the cumulative qty%. See below link for the share:

https://drive.google.com/open?id=1EYU9r_EUvXIXpmrMcwqRkh5iivuDgRyT

 

The pbix file is at below link:

https://drive.google.com/open?id=1T3wi2ENCwqAelFUmxbsftFEtFGRE8a2M

 

Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

Reduce the file size to a few kb's only.  Also, whenever you share a download link, always mention the file size if it it more than 1 MB.  How will i otherwise know the size of the file that i am downloading.

jessiew Frequent Visitor
Frequent Visitor

Re: Calculate cumulative percentage from a calculated column

Hi 

 

 

 

 

 

 

 

Super User
Super User

Re: Calculate cumulative percentage from a calculated column

Hi,

 

You may refer to my solution in this PBIX file.

 

Hope this helps.

 

Untitled.png

jessiew Frequent Visitor
Frequent Visitor

Re: Calculate cumulative percentage from a calculated column

Thanks so much Ashish. It worked. 

Super User
Super User

Re: Calculate cumulative percentage from a calculated column

You are welcome.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 242 members 2,786 guests
Please welcome our newest community members: