Counting a coulumn values from another table

Hi Experts,

I have a table with following values

TABLE 1

Order#         Cell       Count of station

1                        C1              3

2                         C2             3

3                        C3              3

4                         C4              3

I have calculated this count based on another coulumn 'station' in another table which contains some of the values of 'Cell' like

TABLE2

Station

C1

C3

C3

As you can see count in TABLE1 gives sum of count from station.

I want output like this

Order#         Cell           Count of Station

1                         C1                 1

2                         C2

3                         C3                  2

4                         C4

 How this can be achieved. Any help will be appriciated.

I have used following formula for count

Count of station =

CALCULATE(

Count('TABLE2'[station],

ALLSELECTED('TEBLE1'[cell'])

)

Thanks,