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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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