Forum Discussion
Solved
Average Aggregated Data
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. Company Month Value 1 1/1/2025 5 1 ...
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
You are welcome. This simple additional measures will get your desired result
Measure 2 = AVERAGEX(VALUES(Data[Company]),[Measure])
Hope this helps.
Hi,
PBI file attached.
Hope this helps.
Thank you for input. Cookistador's solution was the exact one I was looking for. I think yours might've been averaging in a different order because the Totals came out as 13.33, but I was looking for 18.75.
You are welcome. This simple additional measures will get your desired result
Measure 2 = AVERAGEX(VALUES(Data[Company]),[Measure])
Hope this helps.