Average of Average

[sirros_iot]

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
      

[Phil_Seamark · Accepted solution]

HI @sirros_iot 

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

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

[sirros_iot]

Yes! It's working!

Thank you @Phil_Seamark.

Best Regards,
Diego