Seeking help to make the required faceted matrix with average in each row , and overall average of the last column (Avg.) appearing correctly in position. Currently seems the multiple values overlapping in the overall average score.
Also, would require an expression as title to show the club name and average score for the each club for the relevant coaches. Number of coach in each club is variable (1-3), and position being assessed may vary as well.
Sketch of desired outcome as below.
Link to vega editor as the following:
Helpful resources
Fabric Monthly Update - November 2025
Check out the November 2025 Fabric update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
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.
