Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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])...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Thank you. The calculation is already correct. 144

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Syndicate_Admin , I think the same value is because of filter without using filter function

    try like

     

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

     

    you can move the filter inside the sumx calculate if needed

     

     

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