Forum Discussion

MilanAXVII's avatar
MilanAXVII
Helper I
8 years ago
Solved

related column

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 :)

  • MilanAXVII

     

    Try this

     

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

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion

    MilanAXVII

     

    Try this

     

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