DAX

[Cyriackpazhe]

In the first measure, I'm trying to compute the average quarterly sales and next measure the average montly sales in each year. In the first mesure, i should be getting the year level value in the quarter level as well since there is an ALL function around the quarter column, but why am i getting this result. Same issue with the second measure. Any reason why this is happening

[some_bih]

Hi @Cyriackpazhe try this version for your measure

Quarterly Average Test =
AVERAGEX(
VALUES('Calendar'[Date]),
CALCULATE([Total], ALL('Calendar'[Date]))
)

[Cyriackpazhe]

But what was the error with what i wrote??

It was supposed to give the result as expected right

[some_bih]

Hi @Cyriackpazhe 

measure might aggregate values across all quarters rather than respecting the context of year and quarter