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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
automated_user
Frequent Visitor

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

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:

automated_user_0-1662669062676.png

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

automated_user_1-1662669222680.png

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

automated_user_2-1662669778132.png

Thank you

1 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.

automated_user_0-1662993312013.png

 

 

 

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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.

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

PartNumRowCount.PseudoLinesNonConfig-PNTotal
aaabbb42
cccaaa13
aaaddd02
bbbbbb26
bbbaaa16
dddccc30
aaaddd02

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!

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.

automated_user_0-1662993312013.png

 

 

 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.