Sumif formula

[timward10]

Hi, 

I want to bring back a total amount by person fromthe opportunity table. I have the below formula which is bringing back the total, how do I bring it back so it is against the individual? 

=CALCULATE(sum(Opportunity[Bluesheet yes count]))

Thanks

[timward10]

@Fowmy Worked straight away, thank you! 

[Fowmy · Accepted solution]

@timward10 

You need to create a relationship between the table for this DAX to work.