Forum Discussion
For each instance a string value appears in a column add to a sum for that specific value
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.
Community SupportHi, 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:
| 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!
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.