Forum Discussion

Jsilva96's avatar
Jsilva96
Regular Visitor
2 years ago

Help with DAX

Hello everyone. I would like help with an issue on DAX formulas. (Here the link of the files https://www.transfernow.net/dl/202402077f1pJs0i) Actually i have on a sheet the assistance of the peopl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Jsilva96 ,

Try to use  this DAX:

dotacion_total_ingreso_carozo = 
SUMX(
    FILTER(
        INGRESO,
        SWITCH(
            TRUE(),
            INGRESO[FECHA] <> 'Resumen_Bines_por proceso'[Fecha Proceso], FALSE(),
            INGRESO[TURNO] <> 'Resumen_Bines_por proceso'[TURNO], FALSE(),
            INGRESO[AREA] IN {"PACKING CAROZO"}, TRUE(),  -- Explicitly filter for "PACKING CAROZO"
            TRUE()
        )
    ),
    INGRESO[ASISTENCIA]
)

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.