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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
TomVorves
New Member

STDEV.P - Total Values of a Column, But only within 2 standard deviations?

I’m trying to perform a “standard deviation” calculation on a column, filter any values that are more than 2 standard deviations away from the mean, and then sum the remaining values.

Any ideas? - and Thank you in advnce 🙂

1 REPLY 1
v-jayw-msft
Community Support
Community Support

Hi @TomVorves ,

 

How do you define the "standard deviations", is it a static value?

Please share some sample data and expected result to help us better understanding of your requirement.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors