parameteer
1 TopicPerformance problems with what-if parameter
Hi, I have an important performance using a what-if parameter. The formula below works reasonably well considering that the LLAMADAS table have millions of rows: RACS. = CALCULATE( COUNTROWS( FILTER( SUMMARIZE('Llamadas', LLAMADAS[FK_MATRICULA], "ATEND", LLAMADAS[Llamadas Atendidas]), [ATEND] > 150 ) ) However, when I substitute the threshold of 150 by a what-if parameter the measure doesn't work: RACS. = VAR minLlm = [Umbral Llm] RETURN CALCULATE( COUNTROWS( FILTER( SUMMARIZE('Llamadas', LLAMADAS[FK_MATRICULA], "ATEND", LLAMADAS[Llamadas Atendidas]), [ATEND] > minLlm ) ) ) )770Views0likes4Comments