Forum Discussion
Solved
Sum & average
Hi Guys, Need your support please, I have the following dataset for each of the day: I want to Sum people based on city, then i want to average the city based on flag. so Ger = average...
Download the PBI file.
abukapsoun Try:
Measure = AVERAGEX(SUMMARIZE('Table',[Date],[City],"__Sum",SUM('Table'[People]),[__Sum])
Hi Greg,
It didn't work, it seems there is a syntax error
I am getting the following:
Too few arguments were passed to the AVERAGEX function. The minimum argument count for the function is 2.
As well I got error under:
[__Sum]
Can you maybe send me a pbix for it?