Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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_Points
Regards
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_Points
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
hola victor,
adjunto el link para descargar mi archivo BI y veas
Powerbi2018 es la clave.
Estimado, una ultima consulta.
teniendo claro este escenario: Como puedo hacer para que me valide 2 respuestas. osea en la celda me muestra A,E como puedo decirle mediante código BI que si encuentra una de esas 2 letras les ponga 1 punto.
algo así: VAR Q1_Points = IF ( SELECTEDVALUE ( Test[Q1] ) = "A"; 1; 0 ) OR (( SELECTEDVALUE ( Test[Q1] ) = "E"; 1; 0 ) )
Se que esta lógica no existe pero como podría adaptarlo.
me ayudas pls.
SpoilerHi.
in 5 minutes you will be ready
there is the Excel and the Power BI application
THANK YOU
www.transfernow.net/170069m61p7k
erivera
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |