Forum Discussion

dkel6177's avatar
dkel6177
Regular Visitor
9 years ago

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...
samdthompson's avatar
samdthompson
Icon for Memorable Member rankMemorable Member
9 years ago

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?