cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
curtisk Regular Visitor
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


Capture1.PNG

Can someone please help? 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
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
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
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.

 

Super User
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!




Highlighted
Super User
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])