Forum Discussion
Calculando Notasss
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
- SpoilerHi.
in 5 minutes you will be ready
there is the Excel and the Power BI application
THANK YOU
www.transfernow.net/170069m61p7k
erivera 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.
hola victor,
adjunto el link para descargar mi archivo BI y veas