Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Problem with sumx(values

Hello. Can you help me please. I don't understand what I'm doing wrong. I have this measure. #PAG = CALCULATE(SUMX( VALUES(Resultados_final[MATERIAL]), AVERAGE((Resultados_final[TAMANO_FOTO])...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Syndicate_Admin , Use measure or add calculate in expression

 

#PAG =
CALCULATE(SUMX(
VALUES(Resultados_final[MATERIAL]),
calculate(AVERAGE(Resultados_final[TAMANO_FOTO])
)),Resultados_final[EDICION]="2")