cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

A measure for Sum of the Average that varies with Time

Hello,

How Could I do a measure that sums the average of the "Stops" per Equipment and also per "Start Time and End Time"?

 

The only way I could do it is by averging the "stops" per equipment in a calculated column and then summing the column, but this apporache doesn't make it filter by Start Time.

NaderSaeed_0-1607075471717.png

 

I mean Sum (Average of A Stops + Average of B Stops + .....)

1 ACCEPTED SOLUTION
Super User III
Super User III

Hi @NaderSaeed ,

 

Not really sure if your data is correct since I'm seeing values of end time until 2030 but in the format of dates they seem different also.

 

If you use a simple measure like AVERAGE you can then make the sum of those values with this two measures:

Average = 
AVERAGE('Table'[Stops])

Total = SUMX(VALUES('Table'[Equipment]);[Average])

Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

1 REPLY 1
Super User III
Super User III

Hi @NaderSaeed ,

 

Not really sure if your data is correct since I'm seeing values of end time until 2030 but in the format of dates they seem different also.

 

If you use a simple measure like AVERAGE you can then make the sum of those values with this two measures:

Average = 
AVERAGE('Table'[Stops])

Total = SUMX(VALUES('Table'[Equipment]);[Average])

Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog:

Power BI em Português





View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors