Fill the metric which is duplicated with 0 or average so that the aggregate makes sense

Question

I have a report where one of the metric shows multiple times because its at a higher grain in another dataset which was joined to the original dataset at a product level. How can I fill the duplicated rows with 0 or an average of the number in those rows impacted so that my metric total makes sense. I need two kinds of output if possible. Thank you for the assistance

Deduplicate.xlsx

binu_acs · Answer

@pachopra one way of doing this

Total_1111.yxmd

gautiergodard · Answer

@pachopra got it, sorry i missed the rows all the way at the top.

here is the solution for both.

if you want to add a total row, you can use a summarize tool and sum the entire column.

hope this helps!

New Workflow20.yxmd

pachopra · Answer

Hello - I will try your solution but to clarity no output 1 and output 2 are just two ways to get to the desired goal of getting the aggregate total correctly. Is there a way to get output 1 from the original input