Forum Discussion
how to create a measure with conditional values
Hello everyone, I am struggling with the creation oaf measure. I hope you can help me. I have a table with some measures that are binary (1,0) as follow: Intensidad alta = if(asisten...
The SUMX that are you using you need to specify the table to iterate.
Example:
=SUMX('Tabla1',[expresion])
Regards
Victor
Thank you very much Vvelarde.
my new expression is the following:
New Measure = IF( CALCULATE( table1[Medida] = "Baja" ; SUMX(asistencia; asistencia[Intensidad baja]); IF( table1[Medida] = "Media"; SUMX(asistencia; asistencia[Intensidad media]); SUMX(asistencia; asistencia[Intensidad alta]))))
Nevertheless it doesn`t work. It says that IF mus have at least 2 values. I believe mine has 3 so it shouldn`t be a problem.