How to do running total based on two columns in power BI

[SEPEHR485]

Hello all. I have a dataset consist of Region, Status, Date ,Count. I am trying to show the cumulative Count of Dates based on the status in a clustered chart with lines in PBI. I want to show the cumulative count of act and plan as a separate line. in the first action I need to be able to make a measure for cumulative based on months and status. does anyone know the dax formula for cumulative Act and cumulative pln ? Thanks

 

[SEPEHR485]

Hello all. I have a dataset consist of Region, Status, Date ,Count. I am trying to show the cumulative Count of Dates based on the status in a clustered chart with lines in PBI. I want to show the cumulative count of act and plan as a separate line. in the first action I need to be able to make a measure for cumulative based on months and status. does anyone know the dax formula for cumulative Act and cumulative pln ? Thanks View attachment 64988

here is the DAX I wrote. but it does not do cumulative sum. Does anyone know how to fix it?
Cumulative Target =
CALCULATE(SUM('Sheet1'[Count]), ALLSELECTED('Sheet1'[Type]),'Sheet1'[Type]="Pln")

 

[Toomicek]

Hi Mate,

this video helped me with cumulatives with one column as parameter.