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...
Need Help
Tips and Tricks
  • AmiraBedh's avatar
    AmiraBedh
    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.

     

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
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.

 

Jsilva96's avatar
Jsilva96
Regular Visitor
2 years ago

Thank you for your answer and sorry for provide the information in spanish. The productivity result is based on the "dot_total" measure and not the "dot_emb" so, ¿should i create a measure for any area?

Dot_total_packing= calculate(Average('resumen_bines_por proceso'[dotacion_total_ingreso], 'resumen_bines_por proceso' [AREA] = "PACKING" 

Dot_total_packing_carozo= calculate(Average('resumen_bines_por proceso'[dotacion_total_ingreso], 'resumen_bines_por proceso' [AREA] = "PACKING CAROZO"

 

Dot_total_packing_hand pack= calculate(Average('resumen_bines_por proceso'[dotacion_total_ingreso], 'resumen_bines_por proceso' [AREA] = "PACKING HAND PACK" 
DOT_TOTAL_COMBINED= dot_total_packing + dot_total_packing_carozo + dot_total_packing_hand pack

 

or am i wrong?

Actually,