For each instance a string value appears in a column add to a sum for that specific value

[automated_user]

Hi, 

I need help with getting a summed value based on the number of times a string value from one column appears in another column. For example: 

For each distinct value in a column named PartNum:

take that value and find each instances of it in a column named RowCount.PseudoLines:

For each instance that it is found, I need to sum up the values in the NonConfig-PN field:

Thank you

[v-yalanwu-msft]

Hi, @automated_user ;

From your screenshot, I am confused as to why it is the result of 00111 (link the two figures above).

 Can you use a simple example and want the result to be output? In order to understand your logic and train of thought.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[automated_user]

@v-yalanwu-msft NonConfig-PN can be any range of numbers. But here is an example:

PartNum	RowCount.PseudoLines	NonConfig-PN	Total
aaa	bbb	4	2
ccc	aaa	1	3
aaa	ddd	0	2
bbb	bbb	2	6
bbb	aaa	1	6
ddd	ccc	3	0
aaa	ddd	0	2

So if you take 'aaa' from PartNum and find each instances of it in the RowCount.PseudoLines.. for that instance it appears you would sum up the NonConfig-PN in that row it appears in. So the Total would be '2' for 'aaa'. 

Hope this helps!

[automated_user · Accepted solution]

I was able to figure it out through a measure. In the calculation I also filter by the given year it appears in as well.