Forum Discussion
dofrancis3
Resolver I
Resolver IAvoid duplicates doing the calculations
Dear Colleagues, I would like to request your assistance please ! As you can see in the table below, I have duplicates. How can I proceed to make the calculation (sum) without considering the dupli...
vivek31
Resolver II
Resolver IIHI dofrancis3,
you can use this type of formla to Avoid duplicates doing the calculations
P1 Total = SUMX(DISTINCT('Table (5)'),'Table (5)'[P1])P2 Total = SUMX(DISTINCT('Table (5)'),'Table (5)'[P2])If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you