Apply Standard Deviation to Timeline Data

[maibacherstr]

Hello, I'm hoping anyone with experience applying standard deviation in PBI reports can help.

I'm periodically receiving reports where, for the given EquipmentType, the ReportStatus = "Problem". I'll filter for the EquipmentType using a slicer.

Based on month-by-month data, I want to create a measure that calculates the standard deviation so that I can identify when a upward spike in "problems" arises.

I'm interested to hear your suggestions in how to write this in DAX. Many thanks

[some_bih]

Hi @maibacherstr without dataset, expected output for some inputs iit is hard to support you. Share sample data and expectrd output

[maibacherstr]

Thanks for your patience while I was working through some confusion over doing this for the first time in Power BI. I made great headway and set up the above sample report. I'm confident the calculations are working correctly, but my last step is to visualize the standard deviation measure in the stacked bar/line graph at the bottom. For some reason, the line only registers zero when an EquipmentType is selected, whereas the line should match the stdev calculations shown elsewhere on the screen.

Thanks very much, again.

[maibacherstr · Accepted solution]

The best youtube tutorial on this topic is the following. All my issues were quickly solved based on clear explanation in this video:

Standard Deviation in Power BI | How to create measures for SD, Mean and Upper/Lower Limits - YouTub...

[some_bih]

Hi @maibacherstr for start check https://dax.guide/stdev-p/ or other STDEV.* function. Hope this help