Hi @Anonymous ,
According to your description, I create this data:
Here are the steps you can follow：
1. Create measure calculates the amount of product name to display the duplicate value.
CALCULATE(SUM(Sales[amount]),FILTER('Sales','Sales'[ product name]=MAX('Sales'[ product name])))
2. Create measure changes the duplicate value into a blank value.
Measure 2 =
You can downloaded PBIX file from here.
If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.