Average in graph ignoring filters

[Anonymous]

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:

 https://imgur.com/a/bsNKPIR

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

[Anonymous]

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:

 https://imgur.com/a/bsNKPIR

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 · Accepted solution]

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

[Anonymous]

Hello,

I dug into it and it worked perfectly thanks!

BR