cancel
Showing results for
Search instead for
Did you mean:
curtisk 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 Can someone please help?

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted Super User

## Re: calculate average of a measure

@curtisk

Try with:

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

Regards

Victor

Lima - Peru
Did I answer your question? Mark my post as a solution!

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
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

curtisk Regular Visitor

## Re: calculate average of a measure

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.

Highlighted Super User

## Re: calculate average of a measure

@curtisk

Try with:

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

Regards

Victor

Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! 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])