Create measure to calculate sum based on unique values in another column

[Anonymous]

Hello - please be patient with me as i'm a beginner, but i'm looking to create a measure that will calculate a sum of numbers in one column based on the unique values in another column. Heres my data example:

Agent Name	Leader Name	Total Deficiencies
Agent 1	Leader 1	5
Agent 2	Leader 2	4
Agent 3	Leader 2	7
Agent 4	Leader 1	2
Agent 5	Leader 1	8

What I want to have returned is:

Leader 1: 15

Leader 2: 11

I know this should be pretty straight forward but i've been trying to get this for awhile, and I'd appreciate any help as i'm a beginner. Thank you!

[ryan_mayu · Accepted solution]

@Anonymous 

you can try something like below

calculate(sum(total deficienices),filter(table,leadername="Leader 1"))