Forum Discussion
Calculando Notasss
buenas tardes comunidad,
tengo un caso, tengo un reporte de alumnos con las respuestas que marcaron. Lo que necesito es calcular la nota que obtuvo a partir de un analisis como por ejemplo:
Alumno 01020304 si en la pregunta 1 marco A obtiene una nota de 1 caso contrario 0, Pregunta 2 si marco B obtiene nota 1 caso contrario 0, y así sucesivamente.
Necesito poder calcular la nota que obtendra cada estudiante mediante alguna formula en Power BI. Y al final en una columna mostrar su nota final sumando los puntos obtenidos. No se como hacerlo.
alguien me ayuda por favor.
----------------------------------------
good afternoon community,
I have a case, I have a student report with the answers they marked. What I need is to calculate the note you got from an analysis such as:
Student 01020304 if in question 1 frame A gets a grade of 1 opposite case 0, Question 2 if frame B gets grade 1 otherwise case 0, and so on.
I need to be able to calculate the grade that each student will obtain by means of a formula in Power BI. And at the end in a column show your final grade by adding the points obtained. I do not know how to do it.
somebody help me please.
Thanks
Please double check this:
1. Replace my sample columns Name with yours accord to your table
2. Review if the Answers don't have spaces or another character.
If doesn't work upload a dummy PBIX and share the link.
Regards
Victor
9 Replies
Hi,
You can use a measure to obtain the total:
Calc Points = VAR Q1_Points = IF ( SELECTEDVALUE ( Test[Q1] ) = "A"; 1; 0 ) VAR Q2_Points = IF ( SELECTEDVALUE ( Test[Q2] ) = "B"; 1; 0 ) VAR Q3_Points = IF ( SELECTEDVALUE ( Test[Q3] ) = "D"; 1; 0 ) RETURN Q1_Points + Q2_Points + Q3_PointsRegards
Victor
Lima - Peru
Thanks Vvelarde
Apply your formula and show me 0 values, I do not know why I'm not adding some correct values.
Calc Points =
VAR Q1_Points =
IF ( SELECTEDVALUE ( Test[Q1] ) = "A"; 1; 0 )
VAR Q2_Points =
IF ( SELECTEDVALUE ( Test[Q2] ) = "B"; 1; 0 )
VAR Q3_Points =
IF ( SELECTEDVALUE ( Test[Q3] ) = "D"; 1; 0 )
VAR Q4_Points =
IF ( SELECTEDVALUE ( Test[Q2] ) = "B"; 1; 0 )
VAR Q5_Points =
IF ( SELECTEDVALUE ( Test[Q3] ) = "D"; 1; 0 )
RETURN
Q1_Points + Q2_Points
+ Q3_Points + Q4_Points + Q5_PointsPlease double check this:
1. Replace my sample columns Name with yours accord to your table
2. Review if the Answers don't have spaces or another character.
If doesn't work upload a dummy PBIX and share the link.
Regards
Victor
