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. ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    MilanAXVII

     

    Try this

     

    =
DIVIDE (
    RELATED ( NewTable[time] ),
    CALCULATE (
        COUNTROWS ( timbratura ),
        ALLEXCEPT ( timbratura, timbratura[merged1] )
    )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

MilanAXVII

 

Try this

 

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