Grand Average of different time period

[JB2020]

Hi

I am struggling with the measure 'GrandAverage_LastYear' in the attachment below. I would like to replicate the 'GrandAverage_Selected' measure, but for 'Last Year Count'.

In the workbook I have two tables, one containing unique dates and the other containing dates and a category. The aim is to have a count of dates from the latter and a grand average of those, as well as a comparison of the count of last years dates (Date-364) as well as a grand average of those.

Please let me know if any further explanation is required and thanks in advance.

tmpData.xlsx

Shared with Dropbox

www.dropbox.com

 

[JustynaMK]

Hi JB,

You almost had it - here's the measure that should work for you:

=CALCULATE([Last Year Count], ALLSELECTED())
/COUNTROWS(ALLSELECTED(DateLookup))

Take care,
Justyna

 

[JB2020]

Hi JB,

You almost had it - here's the measure that should work for you:

=CALCULATE([Last Year Count], ALLSELECTED())
/COUNTROWS(ALLSELECTED(DateLookup))

View attachment 28569

Take care,
Justyna

Thank you!