Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Sum values in a column if values in another column are equal

I have some data that I would like to sum, but only if the values in a different column are equal. For example:

Name        Value1         Value2      Value3

Ann              2                  5               1

Ann              1                  2               3

Ann              4                  1               4

Bob              3                  4               2

Bob              1                  1               5

Cat               5                  2               1

Cat               2                  3               1

 

So the value column would be summed if the name column is the same. The new table would look like this:

 

Name   Value1    Value2   Value3

Ann           7           8            8

Bob           4           5            7

Cat            7           5            2

 

I have over 500 names to do this for, so I can't do a measure for each name individually. Any thoughts on this?

 

Thanks!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , if you put Name as unsummarized and value 1, value2 and value 3 as sum in table visual, you will get same

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , if you put Name as unsummarized and value 1, value2 and value 3 as sum in table visual, you will get same

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors