Sum a Column by Several Filters

[Nathan___Mox]

Hey all,

I'm trying to sum a column (amount) filtering by 3 other columns, see below

supplier	grouping	year	amount	New Column
a	1	22	5	15
a	1	22	10	15
a	1	23	10	10
a	2	23	15	15
b	1	22	12	12
b	1	23	3	3
b	2	22	5	15
b	2	22	10	15
b	3	23	20	20

The New column is what I am trying to calculate in Power Bi

Help would be much appreciated, if you need anymore info let me know.

Thanks 

Nathan

[Ahmedx · Accepted solution]

pls try this