Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply

CUMULATIVE POURCENTAGE

Hi

I want to calculate a cumulative % by a DAX Formula (See **bleep**%)

How ?

Client       PURCHASES           %                 **bleep**% 

XX             100                      10%                10%

YY               20                        2%                12%

AA             300                      30%               42%

KK             240                       24%               66%

FF              340                       34%             100%

TOTAL      1000                     100%             100%

1 ACCEPTED SOLUTION

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

What decides the order of the Clients?  Why is KK after XX and so on?  Clarify that.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi

Is done randomly here in my example but on the real work will be ordered from the biggest purshase till the lowest

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
themistoklis
Community Champion
Community Champion

@MoumouhElRebeld 

Try the following formulas:

 

Column_Cumulative_Purchases = 
CALCULATE (
    SUM ( Sheet1[Purchases]),
    ALL ( 'Sheet1' ),
    Sheet1[Client] <= EARLIER ( Sheet1[Client])
)

 

Columnn Cumulative_Purchases % = 
var _totalpurchases = CALCULATE(SUM(Sheet1[Purchases]),ALL(Sheet1))
RETURN
CALCULATE (
    SUM ( Sheet1[Purchases]),
    ALL ( 'Sheet1' ),
    Sheet1[Client] <= EARLIER ( Sheet1[Client])
) / _totalpurchases

 

See attached file 

Hi

Thank you for your effort but i want it on a dax formula to put on a matrix not on a table cause i have thousand of lines, so the purchases per client is calculated with a formula (sum(....)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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