Forum Discussion

BIanon's avatar
BIanon
Helper V
3 years ago

Calculating incremental contribution

Hello Community, I have a case which to me is pretty tricky to get started on. I will explain the scenario and then finish off with some of my own thoughts on how to structure this.   Scenario: ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI  ,try below steps:

 

 

  1. Create a measure to calculate the cumulative sales amount for each product:

     

    DAX

     

     

     

    Cumulative Sales = CALCULATE(SUM(Sales[Amount]), FILTER(ALLSELECTED(Products), Products[ProductID] <= MAX(Products[ProductID])))

     

     

    This measure calculates the cumulative sales amount by summing the sales amount for all products up to the current product based on their ProductID.

    1. Create a measure to calculate the unique contribution to sales for each product:

       

      DAX

       

       

       

      Unique Contribution = [Cumulative Sales] - CALCULATE(SUM(Sales[Amount]), FILTER(ALLSELECTED(Products), Products[ProductID] < MAX(Products[ProductID])))
       

      This measure subtracts the sales amount of the previous products from the cumulative sales amount to calculate the unique contribution.

BIanon

  • BIanon's avatar
    BIanon
    Helper V
    3 years ago

    Hello and thank you for your reply.

    I am currently testing out your method but am experincing that the sum is cumulative across the alphabetical order of my ProductID's (These are unfortunately text strings).

    I need the cumulative sum to start from the product with the highest sales amount and then move down in rank. Is this achieveable ?

    will also continue to see if i can solve it myself