How to calculate average, based on selected Year and Month filter

[MarshalSK]

Hi, Need quick help to calculate average, based on selected Year and Month filter.

expected result

[amitchandak · Accepted solution]

@MarshalSK , This seems like sum not avg

New measures

Sumx(filter(allselected(Table), Table[Year] = max(Table[Year])  && Table[Month] = max(Table[Month]) ), [Sales])

or

Avg

AverageX(filter(allselected(Table), Table[Year] = max(Table[Year])  && Table[Month] = max(Table[Month]) ), [Sales])

Always better to have date table in such cases. Create a date with help from month and year and then have column like year , month in date tbale and have meausres like

(Date table joined with date of your table)

AverageX(filter(allselected(Table), eomonth(Table[Date],0) = eomonth(max(Table[Month]),0)  ), [Sales])