Forum Discussion
Standard Deviation DAX returning zeros
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
4 Replies
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?
You should create is as measure instead of calculated column.
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.
Were you ever able to solve this problem? I'm gettin the same issue.
