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.
Hi @Niiru1
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