Calculate average of measure values datesbetween

[Anonymous]

I have two tables 1. Dimdate = a date key 2 'Table' = data table with PERSON_ID

They are not related as I have created a measure to count % attendance.

If I have calculate the table below:

Is there a way to calculate the average of percentages for PERSON_ID = 135 for dates between DATE(2018,1,1),DATE(2018,12,31) e.g. average of (80.49% & 60% = 70.25%)

I've tried these but cant seem to get them to work.

Measure 4 = AVERAGex(VALUES('Employee Absence Full Table'[Month and Year]),[Measure 3])

or 

Measure 4 = CALCULATE(AVERAGex('Employee Absence Full Table',[Measure 3]),DATESBETWEEN('DimDate'[Dates],DATE(2018,01,01),DATE(2018,12,31)))

File attached: https://www.dropbox.com/s/u5ztxrg4g2g5qpi/Sample3%28updated%29.pbix?dl=0

[AlB]

Hi @Anonymous 

Place this measure in the visual you show, activate the row subtotals and you'll have the result in the row subtotals. For the dates, you can either add slicers or if you want it hard coded, you can use a CALCULATE wrapping the measure.

Measure_TOT = 
AVERAGEX(DISTINCT(DimDate[Month Year]),[Measure 7]) 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers