Forum Discussion

bvy's avatar
bvy
Helper V
5 years ago
Solved

Root Mean Square (RMS) in Power BI Matrix

I currently have a matrix where the cells represent averages of values. But the request now is to use "root mean square" (RMS) as the aggregate. Since that's not one that Power BI offers out of the box, I'm wondering the most straightforward way to implement it. To clarify, RMS is the square root of the average of all the contributing values squared.   

 

 

  • Hi, bvy , it's straightforward,

     

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

     

1 Reply

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion

    Hi, bvy , it's straightforward,

     

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