Forum Discussion

PowerUser2000's avatar
PowerUser2000
Helper I
1 year ago

How to get average across all dates using rolling average?

What I want is when no dates are selected in slicer it should give the user total average percent total between direct deposit accounts and total checking accounts. Currently it is just returning the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi PowerUser2000 

Thanks a lot Elena_Kalina  for you time.

 Use bellow dax. if you still face any issue after above sugestion.

Percent Total direct deposit accounts v3 TEST =
VAR SelectedDates = IF(ISFILTERED(Dates[Date]),VALUES(Dates[Date]),ALL(Dates[Date]))
RETURN 
DIVIDE(AVERAGEX(SelectedDates, [RollingAverageDirectDepositCount33Days TEST]),
AVERAGEX(SelectedDates,[RollingAverageCheckingAccountsCount33Days TEST]),0)

 _________________________________________________________________________________________________________________________
If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.

Reagrds,
Akhil.