Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-danhe-msft's avatar
    v-danhe-msft
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    8 years ago

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

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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