Forum Discussion
Average of Measure
I am working on a sensor data to find the average sound of each working hour and working days for a month, for example, the average sound_mean of 9 o'clock for 30 days. I can filter the working hour...
Hi Anonymous,
Based on my tets, you could refer to below formula:
Measure = CALCULATE(AVERAGE(Table1[sound-mean]),FILTER('Table1','Table1'[Hour]=MAX('Table1'[Hour])))Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
I adjusted the formula like below, and it works fine.
Measure = CALCULATE(AVERAGE(Table1[sound-mean]),FILTER('Table1','Table1'[Hour]=MAX('Table1'[Hour])&&WEEKDAY('Table1'[Date];2)<=5))
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
The first solution gives me the correct results, but the second one doesn't work correctly it still gives me results for weekends and shows blank values for some weekdays.
I adjusted the formula like below, and it works fine.
Measure = CALCULATE(AVERAGE(Table1[sound-mean]),FILTER('Table1','Table1'[Hour]=MAX('Table1'[Hour])&&WEEKDAY('Table1'[Date];2)<=5))