How to refer above value and add to below values

[Anonymous]

Hi,

I have a table and need to add the above values to the below values.

Expected Result

MonthCategory Level 1

6                            2660

12                          3440

18                          4372

24                          4792 

Similar to Level2,3,4 & 5.

Regards,

Yuvaraj

[Vikram123]

Hi You can use bellow Code

Level 1 Running total =
CALCULATE(
SUM('TableName'[Level1]),
FILTER(
ALLSELECTED('TableName'[MonthCategory]),
ISONORAFTER('TableName'[MonthCategory], MAX('TableName'[MonthCategory]), DESC)
)
)

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @Anonymous ,

you can add a column with the following DAX:

Column = CALCULATE(SUM(Table1[Level 1]),FILTER('Table1','Table1'[Month]<=EARLIER('Table1'[Month])))

Best regards

Timo

[Anonymous]

Hi 

Thanks for your reply.

I have Complexity column,  it contains Level1,2,3,4 & 5. Using complexity I have created measures to get the count against every level.

Measure for Level 1:

Level1 = CALCULATE (

sum(tbl_Complexity[CommunityCount]),

FILTER (

ALL ( tbl_Complexity ),

tbl_Complexity[Complexity] = "Level-1"

))

similarly for remaining levels

It's working fine but am expecting to get the running total with the above values. I have tried the running total calculation too but it's not showing correct count.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To create a measure as below.

Measure = 
CALCULATE (
    SUM ( tbl_Complexity[CommunityCount] ),
    FILTER (
        ALLEXCEPT ( tbl_Complexity, tbl_Complexity[Complexity] ),
        tbl_Complexity[Monthcategory] <= MAX ( 'tbl_Complexity'[Monthcategory] )
    )
)