Calculate Average of Average

[neilonbooysen]

Good day Team

I need some guidance on calculating the average of a calculated average

Example example: AVG # Calls is what i am after

[rktoff]

Hello @neilonbooysen,

You can do this with the AVERAGEX function. I am assuming you want the average across your market column in the table…

AVERAGEX( VALUES( [Market] ), [Average] )

Type out the AVERAGEX function, then use the VALUES function and place your market column there. (This creates a virtual table of your list of markets). Then put in the Measure you created called Average.

Let me know if this works.

Thanks,
Randall

[neilonbooysen]

perfect Randall, i had to amend a few things on base calculation but you guided me so thanks alot