Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Hello,
I dug into it and it worked perfectly thanks!
BR
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
76 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |