Calculate average of measure values datesbetween

Anonymous — Sun, 01 Nov 2020 16:07:54 GMT

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])

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

Re: Calculate average of measure values datesbetween

AlB — Sun, 01 Nov 2020 18:07:01 GMT

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

topic Calculate average of measure values datesbetween in DAX Commands and Tips

Calculate average of measure values datesbetween

Re: Calculate average of measure values datesbetween