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 b...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, bvy , it's straightforward,

     

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

     

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, bvy , it's straightforward,

 

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