Avg Rolling 60 days Turn Wrong when filter

[Chanleakna123]

Hi, 

i have using Average Rolling back for 60 days based on Date Slicer. 

but when i filter something else CENTRAL  the number turn wrong.  it means when Filter on Central , There would be Customer Name  compiled together with the Sum of Average Rolling 60 days . but it show only 493 which is not right data , can you help to acheive this ? 

***Avg Rolling 60 days =

CALCULATE (

AVERAGEX ( '60 Days', '60 Days'[Value]),

DATESINPERIOD (

'60 Days'[Date],

LASTDATE ( '60 Days'[Date] ),

-60,

DAY

)

)

[amitchandak]

@Chanleakna123 , formula seems correct but prefer using a date table try like these examples

Rolling 60 = CALCULATE(AVERAGE(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],max(Sales[Sales Date]),-60,DAY))

Rolling 60 = CALCULATE(AVERAGE(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],ENDOFMONTH(Sales[Sales Date]),-60,DAY))