average ignore month

[YBZ]

Hi,

I want to calculate the Monthly Average cost per year.

Currently I have the below :

Monthly Average Cost = Divide(sumx('Table','Table[Cost]), distinctcount('Calendar'[Month])).

This measure is working. I have however a visual on that page and if you select a speific month, the Monthly Average Cost provides the total cost of that month and divides it by the months in that year. What I would like to see is the Monthly Average of that selected year(s). 

I tried the following, 

Monthly Average Cost = Calculate(Divide(sumx('Table','Table[Cost]), distinctcount('Calendar'[Month])), all('Table)). 

That obviously gives me the total average of all years. But I however do not know how to solve it so that I have a Monthly average per year.

Somebody could help me out (I appreciate some explanation to help me get a better understanding for the future) 🙂

Regards

[DataInsights]

@YBZ,

Try these measures:

Total Cost = SUM ( 'Table'[Cost] )

Monthly Average Cost =
CALCULATE (
    AVERAGEX ( VALUES ( Calendar[Month] ), [Total Cost] ),
    // clear Calendar filter context
    ALL ( Calendar ),
    // keep the Year filter context from the slicer
    VALUES ( Calendar[Year] )
)

[YBZ]

Thanks, but that did not work 

It gives me 0 in the table and when I click on a specif month, it gives me strange values 🙂