Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to create a SPC chart, I have calculated the Average sales, but the Standard Decviation is showing 0 and hence the UCL and LCL are showing the same values.
Could someone please help me in this regard.
Link to PBIX - https://drive.google.com/file/d/11PrLUOHrL-r_wO-_NzTjlTVcGCrqaskZ/view?usp=sharing
Many Thanks,
Uday
Hi @udaykiranboppan ,
According to my knowledge, this may caused by Allselected(), please try to use a new measure like this to replace StdDev
StdDev = CALCULATE(STDEVX.P(Sales,'Dimensions'[No of Sales]),FILTER( ALL('Table'),[YearMonthShort]=MAX(YearMonthShort))
Kind Regards,
Bubble
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |