Sum production per Year

[OscarSuarez10]

Hello, I have to sum the production by year like in the following table using DAX, can you help me?

Year	Production			Total
1			1	20
1			2	17
1			3	30
1
1	10
2
2
2
2	5
1
1
1	3
3
3
3	20
1
1
1	7
2
2	12
3
3
3	10

[Anonymous · Accepted solution]

[Total] = SUM ( T[Production] )

where T is your table's name.

If you then drop [Year] on your visual (table, say) and the measure, you'll get what you want.

Best
D