calculate average of a measure

[Anonymous]

HI,

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.

[Ashish_Mathur]

Hi @Anonymous,

Assuming that:

1. There is a calendar table with dates ranging from the first date in your dataset to the last date in your dataset
2. There is a month and year column in the calendar table using the FORMAT(Calendar[Date],"MMMM") and YEAR(Calendar[Date]) functions
3. There is a relatioship from the Date column in your dataset to the Date column in your calendar table
4. Write the following calculated field formula

=AVERAGEX(SUMMARIZE(Calendar,Calendar[Month],"ABCD",COUNT(Table1[ID])),[ABCD])

[Vvelarde]

@Anonymous

Hi, try with

Average = AVERAGEX(VALUES(Table1[Category]),[Total])

Regards

Victor

Lima - Peru

[Anonymous]

Thanks for your suggestion.

Do I have to do something with the [Category]?

My data fields are "date", ID" 

So currently, the return result doesn't work out.

[Vvelarde · Accepted solution]

@Anonymous

Try with:

Average = AVERAGEX(VALUES(Table1[Date].[Month]),[Total])

Regards

Victor