Want cumulative

Hello All I want a cumulative for SBU, tried a lot but not getting the result. Attaching Dax and result's too. As you can see I want cumulative of measure "CalculatedbySBU" and the dax for both ...

Need Help

Jihwan_Kim
5 years ago
Hi, jay_patel
Please try the below measure.

cumulative =
VAR current = [CalculatedBySBU-date]
RETURN
CALCULATE (
[CalculatedBySBU-date],
FILTER ( ALL ( SDirectSales[SBU.SBU] ), [CalculatedBySBU-date] >= current )
)

Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
ryan_mayu
5 years ago
jay_patel

maybe you can try this

cumulative =
CALCULATE (
[CalculatedBySBU-date],
FILTER (SDirectSales,SDirectSales[SBU.SBU] <= MAX( SDirectSales[SBU.SBU] )

i'm sry that I don't quite understand the logic of your second measure.

Jihwan_Kim

Super User

5 years ago

Hi, jay_patel

Please try the below measure.

cumulative =
VAR current = [CalculatedBySBU-date]
RETURN
CALCULATE (
[CalculatedBySBU-date],
FILTER ( ALL ( SDirectSales[SBU.SBU] ), [CalculatedBySBU-date] >= current )
)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.