Sumx with if stantement dont work total (Datediff)- Help

[fabiofurlanbr]

Hey guys,

I need help, I can't add the total using sumX with some if statements , this is the formula I'm using, but as you can see , it doesn't show the total.

My Dax

Horario_Expediente_Loja  =

var _compara_status_inativo_abre_loja =

IF ( SELECTEDVALUE

('Master_Status_Pickup_Tickets (2)'[PickupHour_Status_Pickup_off]) >= SELECTEDVALUE('Master_Status_Pickup_Tickets (2)' [Horario_Inicio-Loja]),

SELECTEDVALUE('Master_Status_Pickup_Tickets (2)'[PickupHour_Status_Pickup_off]),

SELECTEDVALUE('Master_Status_Pickup_Tickets (2)'[Horario_Inicio-Loja])

)

var _compara_status_ativo_fecha_loja =

IF ( SELECTEDVALUE

('Master_Status_Pickup_Tickets (2)'[PickupHour_Status_Pickup_on]) <= SELECTEDVALUE('Master_Status_Pickup_Tickets (2)'[Horario_fecha_Loja]),

SELECTEDVALUE('Master_Status_Pickup_Tickets (2)'[PickupHour_Status_Pickup_on]),

SELECTEDVALUE('Master_Status_Pickup_Tickets (2)'[Horario_fecha_Loja])

)

RETURN

sumx('Master_Status_Pickup_Tickets (2)',

DATEDIFF(_compara_status_inativo_abre_loja,_compara_status_ativo_fecha_loja,MINUTE)

)

[tamerj1 · Accepted solution]

Hi @fabiofurlanbr 

please use 

Horario_Expediente_Loja =
SUMX (
    'Master_Status_Pickup_Tickets (2)',
    VAR Pickup = 'Master_Status_Pickup_Tickets (2)'[PickupHour_Status_Pickup_off]
    VAR Inicio = 'Master_Status_Pickup_Tickets (2)'[Horario_Inicio-Loja]
    VAR _compara_status_inativo_abre_loja =
        MIN ( Pickup, Inicio )
    VAR _compara_status_ativo_fecha_loja =
        MAX ( Pickup, Inicio )
    RETURN
        DATEDIFF (
            _compara_status_inativo_abre_loja,
            _compara_status_ativo_fecha_loja,
            MINUTE
        )
)

[fabiofurlanbr]

Hi @tamerj1 ,

Thanks a lot