topic Re: Calculating maximum value within confidence interval in DAX Commands and Tips

Calculating maximum value within confidence interval

seekmadhav — Tue, 22 Aug 2023 18:06:27 GMT

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.

Re: Calculating maximum value within confidence interval

tamerj1 — Tue, 22 Aug 2023 18:46:27 GMT

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?