I am not sure how to get the average of a measure.
Currently: Total = count (table1[ID])
And I have the following:
I would like to get the average of the all these months to show just one number say in a KPI report: 29K
Can someone please help?
Thanks in advance.
Solved! Go to Solution.
Hi, try with
Average = AVERAGEX(VALUES(Table1[Category]),[Total])
Lima - Peru
Proud to be a Datanaut!