Forum Discussion

jay_patel's avatar
jay_patel
Helper IV
5 years ago

How to get cumulative value.

Hello All

 

Here I am trying to get the cumulative for "Primary Sales LM(%)" with simple dax but it's not working as it is giving 100% for all rows. Mentioning Example below with Screenshot And Dax.

 

cumulative for LM % =
CALCULATE (
[Primary Sales LM(%)],
FILTER (
ALLSELECTED( SDivision ),
SDivision[SBU] <= MAX( SDivision[SBU] )
)
)
 
2)
Primary Sales LM(%) = [PS Previous Month] * 100/[primarysalesFinalfor-LM]

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    jay_patel , Try like

     

    CALCULATE (
    [Primary Sales LM(%)],
    FILTER (
    ALLSELECTED( SDivision ),
    SDivision[SBU] = max( SDivision[SBU])
    )
    )

    • jay_patel's avatar
      jay_patel
      Helper IV
      5 years ago

      Hi Amit

       

      it's giving same value for all rows "100%"

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        jay_patel , Try like.

        CALCULATE (
        Sumx(Values(SDivision[SBU]),[Primary Sales LM(%)]),
        FILTER (
        ALLSELECTED( SDivision ),
        SDivision[SBU] = max( SDivision[SBU])
        )
        )

         

        Can you share sample data and sample output in table format?