Dax allexcept

[Dicken]

I've been trying to use allexcept , and failing,


I have a measure for Monthly average by year ;

AVERAGEX(VALUES('Calendar'[MMM-YYYY]),[Tunits])

Which Have then used in two version to get rolling average

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Rather than using CROSSJOIN ALL and VALUES, could I use ALLEXCPT instead? and if so how?

Richard