Count the positiv and negativ value in a string after aggregation the duplicate values

[NI04001747]

Hello,
In first step, I would like to know how to sum the total of duplicates product Numbers into one and count their postiv and negativ value with only unique product Number. How to sum duplicae product Number into one product?
I would like in second step, to count the positiv and negativ value for each product Number. I would to add the result of the measure in a matrix that contains the product Number, the values per month and the count of postiv and negativ value. In other words, I'd like to create a Matrix visual that the count the postiv and negativ value in a  table range like example below.
In summary, I'd like to keep the above table with unique product Number (after aggregation the value of duplicate values), keep the months with dynamic logic and in the right make the count of unique postiv and negativ values
Thank you in advance for the support

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...