Skip to Content
0
Sep 07, 2023 at 08:07 AM

How to Sum calculation on duplicate rows?

56 Views

Hi All,

So this is the main table:before-duplicate.jpg

and i also summerized it on different tables

before-finish-time-dimensions.jpg

The result is fine , but i need to add another dimension and is giving the info of finish time , which make each/some rows duplicate:

finish-time.jpg

row duplicates:after-duplicate.jpg

this

affects the summarized table results which i know because the rows are duplicated after i add the dimension of spesific finish timeafter-finish-time-dimensions.jpg

i have already using ForEach, ForAll, In functions but it returns multivalue and ticking the avoid duplicate row also i have tried to change the cardinality on the data foundation but the result is the same. Does anyone know how to sum without it being not duplicated?

Thank you in advance

Rev