I would like to create a measure in powerBI that is the standard deviation of distinct count by month

Question

I want to create a measure in Power Bi which shows the standard deviation of the distinct counts of IDs by month

Month | ID
1       A
1       B
1       A
2       C
2       D
2       E
3       F
3       G

The Counts would be:
Month | Distinct Count
1       2
2       3
3       2

 

Answer 1

Use the following formula

Standard Deviation = 

var grouped_table = SUMMARIZE('Table','Table'[Month],"Distinct Count",DISTINCTCOUNT('Table'[ID]))

var st_dev = STDEVX.P(grouped_table,[Distinct Count])

return(st_dev)

If u want to know more about Power BI, one of the powerful BI tools, then join the Power Bi course