cancel
Showing results 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

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:

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

1 ACCEPTED SOLUTION
Frequent Visitor

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.

3 REPLIES 3
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.

Frequent Visitor

@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!

Frequent Visitor

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.

Announcements

#### 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 Monthly Update - June 2024

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

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors