Two tables

[firstligth62]

I have two tables

Table 1

Date            Line
01/01/2019     line 1
01/01/2019     line 2
01/01/2019     line 1
01/01/2019     line 3
01/01/2019     line 5
01/01/2019     line 1

Table 2

Date          Line         Nbr Trafic
01/01/2019    line 1       50
01/01/2019    line 2       2
01/01/2019    line 3       10
01/01/2019    line 4       5
01/01/2019    line 5       1


and I would like to have a table 3 with  line table 1 / nbr trafic table 2
Table 3

Date             Ligne        Re
01/01/2019       line 1       0,06
01/01/2019       line 2       0,5
01/01/2019       line 3       0,10
.......
.
.

Table 1 and Table 2 are jointed by Line

Can you help me please?

[hthota]

If you need as a new table. Please create the dulipcate of table 1 and merge the table 2 with duplicate table. Expand the columns and create the Calculate column as above it would work out.

Thanks,

Hemanth Thota.

[parry2k · Accepted solution]

@firstligth62 add a new measure with following expression

Re = 
DIVIDE( COUNTROWS( Table1 ), SUM( Table2[Nbr Traffice ) )

Add a table visual and put Date, Line and Re from Table2