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.
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
Thank you, this worked perfect! Now I am going to try on more complicated Measure rather than value!
