'Average of measures to re-calculate if a filter is applied - Power BI
I have the following calculated measure:
I also have a series of drop-down filters, such as the name of the agent, report date on the page, etc.. I need to calculate the average of the measure which will be re-calculated if any filter is applied, e.g. a date period is selected or a name of the agent is picked, etc. I tried with
=averagex(values(date,date.[Month]), [% of requests (urgent and not-urgent]).
It doesn't work if the incomplete date range is selected, e.g. from the 5th of Jan till now or when the agent filter is applied. What am I doing wrong?
Solution 1:[1]
Using the AVERAGEX function, it calculates the average of the criteria that will be recalculated in any filtering process that I create from the data I have. At the same time, the data centered on the date that can be set in the slicer is being calculated.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Beyza Nur AY |


