Root Mean Square (RMS) in Power BI Matrix

[bvy]

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.   

[CNENFRNL · Accepted solution]

Hi, @bvy , it's straightforward,

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