Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Help with average filtering

Hello. I have the following problem. I have a sheet with a date filter above and then in the graph below I have OC quantity (distinctive count), OC lines (count of all) and a maximum of OC in a day....
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Syndicate_Admin , Not very clear,. But you need a daily average of a measure

 

Averagex(Values(Date[Date]), [Measure])

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    Actually I need to get an average of some of the data that the graph shows (in this case, the numbers below in lighter green). The graph changes when I select different dates above.