cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Root Mean Square (RMS) en Power BI Matrix

Actualmente tengo una matriz donde las celdas representan promedios de valores. Pero la solicitud ahora es usar "root mean square" (RMS) como agregado. Dado que no se trata de uno que Power BI ofrece de fábrica, me pregunto la forma más sencilla de implementarlo. Para aclarar, RMS es la raíz cuadrada de la media de todos los valores contribuyentes al cuadrado.

bvy_0-1602424509612.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Hola, @bvy, es sencillo,

Measure RMS = SQRT(AVERAGEX(tb, tb[Value]^2))

View solution in original post

1 REPLY 1
Highlighted
Resident Rockstar
Resident Rockstar

Hola, @bvy, es sencillo,

Measure RMS = SQRT(AVERAGEX(tb, tb[Value]^2))

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors