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])
)),Resultados_final[EDICION]="2")

With this measure I get this table.

The subtotal gives 155.20 and you shouldn't add that up. The actual result should be 144.

That adds up to all the values in the table.

I DON'T UNDERSTAND WHAT I DO WRONG. PLEASE HELP ME.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super 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")

    • 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") ))
      ))