cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iamrehpotsirhc
Regular Visitor

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

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 NameLeader NameTotal Deficiencies
Agent 1Leader 15
Agent 2Leader 24
Agent 3Leader 27
Agent 4Leader 12
Agent 5Leader 18

 

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!

1 ACCEPTED SOLUTION
ryan_mayu
Super User II
Super User II

@iamrehpotsirhc 

you can try something like below

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User II
Super User II

@iamrehpotsirhc 

you can try something like below

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors