cancel
Showing results for
Did you mean:
Regular Visitor

## calculate average of a measure

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: calculate average of a measure

@curtisk

Try with:

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

Regards

Victor

Lima - Peru

Proud to be a Datanaut!

4 REPLIES 4
Super User

## Re: calculate average of a measure

@curtisk

Hi, try with

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

Regards

Victor

Lima - Peru

Lima - Peru

Proud to be a Datanaut!

Regular Visitor

## Re: calculate average of a measure

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

My data fields are "date", ID"

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

Super User

## Re: calculate average of a measure

@curtisk

Try with:

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

Regards

Victor

Lima - Peru

Proud to be a Datanaut!

Highlighted
Super User

## Re: calculate average of a measure

Hi @curtisk,

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])