Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
I think you have a bracket in the wrong place. Please try this..
Horas = CALCULATE(SUM(Jornadas[Jornada]),RELATEDTABLE('Jornadas'))
By the way, you may also use SUMMARIZE Function.
Table = SUMMARIZE ( Jornadas, Jornadas[Crew Name], "Horas", SUM ( Jornadas[Jornada] ) )
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') )
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!
I think you have a bracket in the wrong place. Please try this..
Horas = CALCULATE(SUM(Jornadas[Jornada]),RELATEDTABLE('Jornadas'))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |