Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Solved! Go to Solution.
@Anonymous , if you put Name as unsummarized and value 1, value2 and value 3 as sum in table visual, you will get same
@Anonymous , if you put Name as unsummarized and value 1, value2 and value 3 as sum in table visual, you will get same
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |