The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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?
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |