Forum Discussion

Jsilva96's avatar
Jsilva96
Regular Visitor
2 years ago
Solved

Ayuda con con formula DAX

Hola, buenas tardes. Esperando que se encuentren bien, les quería presentar el siguiente problema que me ha surgido en Pbi desktop (Dejo link de descarga) https://we.tl/t-AVgftAbrjl Ocurre que ten...
  • AmiraBedh's avatar
    2 years ago

    You first need to create a seperate measure for each area : 

    Dot_emb_Packing = CALCULATE(
        AVERAGE('Resumen_Bines_por proceso'[dotacion_embalaje_ingreso]),
        'Resumen_Bines_por proceso'[AREA] = "PACKING"
    )
    
    Dot_emb_Packing_Carozo = CALCULATE(
        AVERAGE('Resumen_Bines_por proceso'[dotacion_embalaje_ingreso]),
        'Resumen_Bines_por proceso'[AREA] = "PACKING CAROZO"
    )
    
    Dot_emb_Hand_Pack = CALCULATE(
        AVERAGE('Resumen_Bines_por proceso'[dotacion_embalaje_ingreso]),
        'Resumen_Bines_por proceso'[AREA] = "PACKING HAND PACK"
    )

     Then, you can combine these measures to get the calculation you need. For example, if you want the sum of the dotations from the three areas, you could do something like this:

    Dot_Total_Combined = Dot_emb_Packing + Dot_emb_Packing_Carozo + Dot_emb_Hand_Pack

     

    Please note this is an English forum, do not forget to provide your information in English.