Forum Discussion

sshantaram's avatar
sshantaram
Frequent Visitor
5 years ago
Solved

Cumulative Dax expression for multiple dimension - Product and Year-Month

Hello All,

 

I want to achieve cumulative growth of Product with respective to Year-Month. I am able to achieve it with respect to Year-Month but when I try to achieve it based on other dimension like Product, my logic fails. I am sharing a simple example in the screenshot

 

 

Kindly let me know if there is a way to achieve this, also will the logic apply to Product-->Sub-Product-->Year-Month

 

Thank you for your time

 

Warm Regards

SK

Need Help
Show and Tell
Tutorial Requests

4 Replies

    • sshantaram's avatar
      sshantaram
      Frequent Visitor
      5 years ago

      amitchandak Thank you for your reply. I have used this calculated measure before "calculate(sum(Table[Value]) , filter(allselected(year), Year[Year] <=  Max(Year[Year])))" but it only works when you have only Time Dim .. but if you add a Product Dim along with Time Dim, we wont get the result. 

       

       

      Kindly help.

       

      Warm Regards,

      SK

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, sshantaram 

     

    To create a measure like this:

     

    Measure =
CALCULATE (
    SUM ( 'Table'[Sales] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Product] ),
        'Table'[Date] <= MAX ( 'Table'[Date] )
    )
)

     

    Result:

    Please refer to the attachment below for details

     

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.