Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
udaykiranboppan
Regular Visitor

SPC Charts how to calculte the UCL and LCL

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.

 

udaykiranboppan_0-1659961737322.png

 

udaykiranboppan_2-1659961900901.png

udaykiranboppan_0-1659962289366.png

 

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

1 REPLY 1
Bubble4502
Resolver III
Resolver III

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.