Cumulative sum base from 2 to 3 filter

[AllanBerces]

Hi good day can anyone amend correct my cumulative calcualted column.

CUM_Plan = VAR CurrentDate = 'Table'[Plan Date_Main]

                              VAR CurrentSubTask = 'Table'[Location]

                              VAR Filteredtable = FILTER('Table','Table'[Plan Date_Main]<=CurrentDate && 'Table'[Location]= CurrentSubTask)

                              return

                              CALCULATE(SUM('Table'[Plan Hrs]), Filteredtable)

Output

Thank you

[SachinNandanwar · Accepted solution]

Hi,
Is this what you are looking for ?

CUM_Plan =                    
                              VAR CurrentDate = 'Table'[Plan Date_Main]
                              VAR CurrentSubTask = 'Table'[Location]
                              VAR CurrentGroup = 'Table'[Group]
                              VAR Filteredtable = 
                                  FILTER('Table',
                                  'Table'[Plan Date_Main] <=CurrentDate 
                                  && 'Table'[Location]= CurrentSubTask 
                                  && 'Table'[Location]=CurrentGroup)

                          RETURN  CALCULATE(SUM('Table'[Plan Hrs]), Filteredtable)

[AllanBerces]

Hi @SachinNandanwar thank you very much for the reply, all good.