Forum Discussion
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....
Syndicate_Admin , Not very clear,. But you need a daily average of a measure
Averagex(Values(Date[Date]), [Measure])
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.