Make averagex to work properly with dimensions

[Anonymous]

I have my measure where I am trying to display an average... The average should change by month and of course take into account BLANKS.

So, if I have data:

June: 3

July: 4

August: BLANK

I want to see (for the selected month):

June: 3

July: 3,5 

August: 2,333

To achieve this I use     CALCULATE (  [Users Avg Months] ,DATESYTD('Date'[Date] ,"31/05")  )

It works fine with TOTALS!! ; but when I drag "user type" from  Dimension it works wrong.

My code is:

Users:=CALCULATE(SUM(Users[Actual]), FILTER('User Type', ' User Type'[C Or A] IN {"A"} ))

Users Avg Months:= AVERAGEX (   VALUES('Date'[DW_SK_Date]),[Users]  )

[Anonymous]

I get an error saying I cant use COALESCE. (The engine is SSAS 2019)

[tamerj1]

@Anonymous 

Try

Users Avg Months :=
AVERAGEX ( VALUES ( 'Date'[DW_SK_Date] ), [Users] + 0 )

[tamerj1]

Hi @Anonymous 
Please try

Users Avg Months :=
AVERAGEX ( VALUES ( 'Date'[DW_SK_Date] ), COALESCE ( [Users], 0 ) )