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
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors