Need Help to fix the total value for 30 rolling days and 90 rolling days issue

[Santhosh0579]

Need Help to fix the total value for 30 rolling days and 90 rolling days issue (Input date from Date slicer)

Formula :

Totallogin = var t=SUMMARIZE('userloggedinacc','userloggedinacc'[CountryCode],"UserDistinct",DISTINCTCOUNT(userloggedinacc[UserID] ))return SUMX(t,[UserDistinct])

30-Days Rolling = CALCULATE([Totallogin],DATESINPERIOD(dimdate[CalendarDate],MAX(userloggedinacc[LoggedInOn]),-30,DAY))

90-Days Rolling = CALCULATE([Totallogin],DATESINPERIOD(dimdate[CalendarDate],MAX(userloggedinacc[LoggedInOn]),-90,DAY))

I will appriciate any advice how to accomplish that. 

[Santhosh0579]

Guys,

Thank you so much for your support, Have modified the below Dax formula

and it is working as expected both Matrix and cluster columnchart.

Formula :

Totallogin = var t=SUMMARIZE('userloggedinacc','userloggedinacc'[CountryCode],"UserDistinct",DISTINCTCOUNT(userloggedinacc[UserID] ))return SUMX(t,[UserDistinct])

30-Days Rolling = CALCULATE([Totallogin],
Filter (ALL(dimdate),
dimdate[CalendarDate] > MAX(dimdate[CalendarDate])-30 &&
dimdate[CalendarDate] <= MAX(dimdate[CalendarDate])
))

90-Days Rolling = CALCULATE([Totallogin],
Filter (ALL(dimdate),
dimdate[CalendarDate] > MAX(dimdate[CalendarDate])-90 &&
dimdate[CalendarDate] <= MAX(dimdate[CalendarDate])
))

[aditya0125]

Did you check relationship between the tables.

[Santhosh0579]

Hi Aditya,

Yes relationship is there with bussinesskey

[aditya0125]

okay, try to enble cross filter(Both), bcoz the dax you wrote is perfectly okay(jst check summerize dax again).

[Santhosh0579]

Hello Team, 

Is someone able to help to fix this DAX Formula?

Thank you inadvance