cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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:

 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

1 ACCEPTED SOLUTION
Thejeswar
Solution Sage
Solution Sage

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

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Solution Sage
Solution Sage

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

View solution in original post

Anonymous
Not applicable

Hello,

 

I dug into it and it worked perfectly thanks!

 

BR

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors