Forum Discussion
Average in graph ignoring filters
Hello,
I'm a total newbi in powerbi and I got a huge problem.
Here is some screenshot since I don't know the name of the elements.
My db is a sharepoint list created thanks to powerapps. I need to display the number of activities handle by manager and an average of this (including all the managers). Here are some screens:
Average "Variant" is the Average of "Current Variant". If no manage is selected the Average is good, it include all the manager. But If I select only one manager the average will be equal to the current variant. I understand why but I would like to display the average of all manager even if I select one manager. Any Ideas how should I do?
Best Regards,
Basien
Hi Anonymous,
If you are using acheiving Average function by setting the property to Average with your measure, then it is not possible to show the Average Values even when the Manager Name is filtered.
Instead if you are using a DAX function to calculate the Average of the values, then using ALL() DAX Function will help eliminate the consideration of the filters to the calculation.
The Below is the details about ALL DAX function. This should help achieving this
https://msdn.microsoft.com/en-us/query-bi/dax/all-function-dax
3 Replies
Hello,
I'm a total newbi in powerbi and I got a huge problem.
Here is some screenshot since I don't know the name of the elements.
My db is a sharepoint list created thanks to powerapps. I need to display the number of activities handle by manager and an average of this (including all the managers). Here are some screens:
Average "Variant" is the Average of "Current Variant". If no manage is selected the Average is good, it include all the manager. But If I select only one manager the average will be equal to the current variant. I understand why but I would like to display the average of all manager even if I select one manager. Any Ideas how should I do?
Best Regards,
Basien
- Thejeswar
Super User
Hi Anonymous,
If you are using acheiving Average function by setting the property to Average with your measure, then it is not possible to show the Average Values even when the Manager Name is filtered.
Instead if you are using a DAX function to calculate the Average of the values, then using ALL() DAX Function will help eliminate the consideration of the filters to the calculation.
The Below is the details about ALL DAX function. This should help achieving this
https://msdn.microsoft.com/en-us/query-bi/dax/all-function-dax