How to get cumulative value.

[jay_patel]

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]

[amitchandak]

@jay_patel , Try like

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

[jay_patel]

Hi Amit

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

[amitchandak]

@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?

[jay_patel]

Hey Amit

Thanks for your efforts, but above mentioned dax does'nt worked,all are giving same result. i.e., 100 % for all rows. 

So I tried this dax

**bleep** for % =

CALCULATE (

[Primary Sales LM(%)],

FILTER (

ALLSELECTED( SDivision ),

SDivision[SBU] = MAX( SDivision[SBU]) && [Primary Sales LM(%)] >= ([Primary Sales LM(%)])

)

)

and i would like to add ''MIN'' Function in the last line for '[Primary Sales LM(%)]' but it's a measure so it will not work, and i can't convert it into Calculated column. So can you help me to suggest any alternate dax for this.

Thanks in Advance

[v-shex-msft]

Hi @jay_patel,

Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@jay_patel , sorry I missed Less than , but 100% create a doubt

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