Standard Deviation DAX returning zeros

[dkel6177]

I have table that provides a count of reports by a particular offense group;

My DAX is set to:

STDdev = STDEVX.P(ucr2st, 'Master KPI'[Report Count]) 

see below.... I keep getting zeros. What am I doing wrong....lol

[BhaveshPatel]

You should create is as measure instead of calculated column.

[dkel6177]

I have, but i just put it in a column to see the result instead of a visual. Either way does not work. I just get zeros. I need a standard dev at the group level shown above. 

[cworkman2015]

Were you ever able to solve this problem? I'm gettin the same issue. 

[samdthompson]

Hi, the formula at first glance looks fine. The things that could be going wrong it how it is seeing the data in report count field. Is this a blank()? STDEVX.P() is meant to ignore it if thats the case (or if 0) but i have had problems with it in the past. To fix it I found that a filter on data to ignore the blank's or 0's worked weel for me. Are you able to share a PBIX?