Calculate Column in New table

[lorenacardona]

Hi,

I want to make a new table that for a specific name gives me the sum of hours that they work.

So I already filter the names with this formula:   Pilotos = DISTINCT(Jornadas[Crew Name])

The problem is that i dont know how to make the fomula that sum the hours if the name at Table A is the same name at Table B.

I was trying with this formula:   Column = CALCULATE(SUM(Jornadas[Jornada]),FILTER(ALL(Jornadas[Crew Name])))

Regards!

[v-chuncz-msft]

@lorenacardona,

By the way, you may also use SUMMARIZE Function.

Table =
SUMMARIZE ( Jornadas, Jornadas[Crew Name], "Horas", SUM ( Jornadas[Jornada] ) )

[Phil_Seamark]

Hi @lorenacardona

If you have created a calcuated column as you say, just create a relationship between your existing table and your new table as follows

Then you can add the following calcuated column to your Pilotos table

Column = CALCULATE(
                SUM(Jornadas[Jornada]),
                RELATEDTABLE('Jornadas')
                )

[lorenacardona]

I already made the relation between the two tables and this message appears when I put the formula:

Horas = CALCULATE(SUM(Jornadas[Jornada],RELATEDTABLE('Jornadas')))

"Too many arguments were passed to the SUM function. The maximum argument count for the function is 1."

Thanks!

[Phil_Seamark · Accepted solution]

Hi @lorenacardona

I think you have a bracket in the wrong place.  Please try this..

Horas = CALCULATE(SUM(Jornadas[Jornada]),RELATEDTABLE('Jornadas'))

[lorenacardona]

@Phil_Seamark it worked! thank you so much for everything.

You really helped me.

Regards!