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 l...
Need Help
Show and Tell
Tutorial Requests
  • v-angzheng-msft's avatar
    v-angzheng-msft
    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

sshantaram , first you need to unpivot the year data.  That will give value column

https://radacad.com/pivot-and-unpivot-with-power-bi

You need to have a year table 

Create a measure like one below and use in matrix with year and product

calculate(sum(Table[Value]) , filter(allselected(year), Year[Year] <=  Max(Year[Year])))

  • 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