How to calculate the standard deviation in powerbi?

[Anonymous]

In excel it is used the function sumproducts, but in power bi there is no such function, how can I calculate the standard deviation?

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

After research, you can use sumx function, I create the following example.



In Power BI, create a measure using the DAX.

result = SUMX(Table2,Table2[A]*Table2[B])

Create a card to diaply it, it return correct result as the following screenshot.


Best Regards,
Angelia

[KHorseman]

https://msdn.microsoft.com/en-us/library/gg492207.aspx