ADD AS IN SUMIF DOES NOT WORK

[walkra]

Hi,  How are you. There is something that I am not doing well. I just want to do a sum as I do with SUMIF in Excel but in Power Bi.

I have a query where I want to add "Horas" according to the value of "Codigo Cliente". For example, in the attached image, in "Columna in the records of the "Client Code" TEC, the value 107855 should appear, but it gives an error or the same number appears in the record. It does not present the sum.

I have tried many formulas but none worked. Now I am using: 

Columna = CALCULATE(sum(Hoja1[Horas]),all(Hoja1[Codigo Cliente]))

(maybe my lack of English makes me make mistakes when I transfer what I understand to Power BI)

Thank You Very Much. 

[HotChilli · Accepted solution]

You can go with this

CodeTotal = VAR _Code = Hoja1[Codigo Cliente]
            
RETURN
    CALCULATE(SUM([Horas]), 
        FILTER(Hoja1, Hoja1[Employee] = _Code))

[walkra]

Excellent! Thank You very much