I have a table like following. **Note I put an empty column in tables so can read Value....without empty column the numbers were hard to read.CompanyMonth Value11/1/2025 512/1/2025 4012/1/2025 5052/1/2025 1052/1/2025 2052/1/2025 3053/1/2025 053/1/2025 10 For scoring I want to average the Value by Company and monthCompanyMonth Value11/1/2025 512/1/2025 4552/1/2025 2053/1/2025 5 Then I want to average by Company the above table. So when shown in visual with Company only, it should be like belowCompany Value1 255 12.5 Then At Total level it should be average of above: 18.75. I have tried using Summarize/addcolumns/AverageX and no luck. What I have now is following which works except at Total level: Meeasure =VAR MonthlyAverages = SUMMARIZE( data, data[Company], data[Month], "Monthly/Company Average", CALCULATE(AVERAGEX( data, data[Value] )) )var ContractorScoringTable =SUMMARIZE( MonthlyAverages, data[Company], "Score per Company",AVERAGEX(MonthlyAverages,[Monthly/Company Average]))VAR Result = AVERAGEX(ContractorScoringTable, [Score per Company])RETURN Result

You can use the following measure in a matrix: Average Measure= AVERAGEX( VALUES('Table'[Company]), AVERAGEX( VALUES('Table'[Month]), CALCULATE(AVERAGE('Table'[Value])) ) ) This is the result I get: Do not hesitate to ask if you need more support

Average Aggregated Data | Microsoft Fabric Community

Forum Discussion

Related content

Average monthly sales buy aggregated

Data Aggregation issue

Aggregate monthly data into quarterly average

Stop Data Aggregation on a Matrix

Monthly averages - Calculated column - Aggregation