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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
seekmadhav
New Member

Calculating maximum value within confidence interval

Hello,

 

I have a list of students from grades 3 - 12 and how much pages they have printed over the last two years. I need to create a visual that can show the maximum printed pages for 95% of the students per grade. 

I am very new to DAX and Statistics. If someone can help me develop this, I will really appreciate you. 

 

1 REPLY 1
tamerj1
Super User
Super User

@seekmadhav 

Not sure if I fully understand the requirement. However 95.4% is equivalent to +- 2 standard deviations. Do you mean to say that you want to calculate the number of printed papers of the student who is +2 stdev's away from the mean value?

Helpful resources

Announcements
November Fabric Update Carousel

Fabric Monthly Update - November 2025

Check out the November 2025 Fabric update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (27)