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 BIanon ,

check below measures

Product Rank = RANKX(ALL('YourTable'[ProductID]), SUM('YourTable'[SalesAmount]), , DESC, Skip)

 

or 

 

Cumulative Sales = 
SUMX(
   FILTER(
      ALL('YourTable'),
      'YourTable'[Product Rank] <= EARLIER('YourTable'[Product Rank])
   ),
   'YourTable'[SalesAmount]
)

 

 

 

Please Accept as Solution If resolved your problem!!!

BIanon's avatar
BIanon
Helper V
3 years ago

Thank you once again.

The [Product Rank] measure, would that have to be a calculated column?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI BIanon ,

    yes try with calculated column

    • BIanon's avatar
      BIanon
      Helper V
      3 years ago

      Hello again,

      I tried adding the ranking to my dimension via my DW as the calc. col was too much to run on my model.

      The problem is, doing it this way removes the ability to slice on time since the value i am ranking on needs to change as the user moves the time slicer.

      I can rank dynamically, but I can't find a way to then work with those rankings since EARLIER() only accepts a col ref

      Do you have an idea for this?

      Also, thank you so far for your time and knowledge