related column

[MilanAXVII]

Hi,

I have two tables which are linked by one column

for each colum(merged 1) I have one time

One the other table I have all merged 1, but sometimes there are many merged 1 which are similar.

when i do "related" function to put time from new table to timbratura, i have for the merged which are similar, the sum of time of this type of merged

How can I have a column without sum?

I would like a 0 on the second (or third in other case) similar merged 1 or if its possible, divide the time corresponding to merged 1 by the number of time that i can find the same merged 1

i dont know if am i clear, but i need help.

thanks 🙂

[Zubair_Muhammad · Accepted solution]

@MilanAXVII

Try this

=
DIVIDE (
    RELATED ( NewTable[time] ),
    CALCULATE (
        COUNTROWS ( timbratura ),
        ALLEXCEPT ( timbratura, timbratura[merged1] )
    )
)