Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |