Cumulative running total of measure

[ziyabikram96]

Hello 

I want to find the running total of the mesure which i created , but it is giving me same value as measure. in Measure1 i counted the product then i want the runnig total of this product in meaues2 .

Meausre1= 

CALCULATE(DISTINCTCOUNT(CUSTOMERS[Customer Key]),USERELATIONSHIP(CUSTOMERS[Created Date],'CALENDAR'[Date]))

For Measure 2 i use this 

Measure2 =CALCULATE([Dist count Customer],FILTER(ALLSELECTED(CUSTOMERS),CUSTOMERS[Created Date] <= MAX(CUSTOMERS[Created Date])))

now i want running total i try many approch but faild. below is the output what i want. 

Month	Measure1	Measure2
Jan	5	5
Feb	10	15
Mar	5	20
Total	20	20

[amitchandak · Accepted solution]

@ziyabikram96 , Try like this

Measure2 =CALCULATE([Dist count Customer],FILTER(ALLSELECTED(CALENDAR),CALENDAR[Date] <= MAX(CALENDAR[Date])))

You should use month from date table in visual

[ziyabikram96]

yes its working thanks