Forum Discussion
Jsilva96
2 years agoRegular Visitor
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...
- 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_PackPlease note this is an English forum, do not forget to provide your information in English.