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...
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?