Hi there, so far I did not find yet a working solution for following problem (sorry, I am new to Power BI): I would like to create a measure "overall average" which also shows up in matrix view in each row. In this example the average contacts of all 3 teams is 217 and this value should be shown like this. The measure for "overall average" is working as long as I just use the total view, but not with the fifferent teams in the rows.
Thank you in advance for your help!
Hi @dkc Try this:
Average = AVERAGEx(ALLSELECTED(TeamTable),TeamTable[Contacts])
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Hi @dkc Try this:
Average = AVERAGEx(ALLSELECTED(TeamTable),TeamTable[Contacts])
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
