Reply
Member
Posts: 63
Registered: ‎11-28-2017
Accepted Solution

Average of Average

Hello All!

I have this sheet as example of data

https://drive.google.com/file/d/1NjNrDtDuRZSNFSvja0LCVJ6eF69LInmS/view?usp=sharing

I have a measure that does it:

Measure A = (MAX( RealTimeData[_ts]) - MIN( RealTimeData[_ts)) / COUNT( RealTimeData[sensor])

So, I put it into the visual table, and Measure A works with the time slicer and is filtered and by sensor as I put it into the table.
sensor         Measure A
A                        X
B                        Y
C                        Z

But, I would like to make also de average with X, Y, Z.
Example: X = 1, Y = 2, Z = 3.
Measure B = 2

Any Idea?
Thanks,
Diego
      


Accepted Solutions
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Average of Average

HI @sirros_iot 

 

Is this what you mean?  I have attached a PBIX file

 

Measure = AVERAGEX(VALUES('RealTimeData'[sensor]),[Measure A])

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Attachment

All Replies
Super User
Posts: 2,618
Registered: ‎11-29-2015

Re: Average of Average

HI @sirros_iot 

 

Is this what you mean?  I have attached a PBIX file

 

Measure = AVERAGEX(VALUES('RealTimeData'[sensor]),[Measure A])

image.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Attachment
Highlighted
Member
Posts: 63
Registered: ‎11-28-2017

Re: Average of Average

Yes! It's working!

Thank you @Phil_Seamark.

Best Regards,
Diego