Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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%

Need Help

5 Replies

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous 

    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 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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(....)

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi

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