How to count the number of identical IDs in a column?

[Marley2100]

Dear community, 

I am very new to PowerBI and have been searching for a workable solution for my issue for some time. I believe that the solution must be rather simple, but I could not make any of the proposed solutions work.

My goal: I have a table with 2 columns: ID and Product. Some IDs are duplicated. I want to add a third column in which the number of duplications for the ID in the same row is pointed out. 

Example result (Table1):

ID	Product	No of Duplicates
123	A	1
124	B	2
124	C	2
125	D	1
126	E	1
127	F	3
127	G	3
127	H	3

Progress: 

I tried a couple of formulas, but somehow fishing in the dark. Especially, I dont get the EARLIER working, which I assume could solve the problem at hand. 

No of Duplicates = CALCULATE(
    COUNT('Table1'[ID]), 
    FILTER('Table1', 'Table1'[ID] = EARLIER(ID)))

No of Duplicates = 
CALCULATE (
    COUNTROWS(FILTER('Table1',
        'Table1'[ID]='Table1'[ID]

    )

))

If someone could help me here, that would be highly appreciated. Thanks a lot for any support in advance.

[Ashish_Mathur]

Hi,

This calculated column formula works

=CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])))

[smpa01 · Accepted solution]

@Marley2100 

Measure = calculate(count(tbl[id]),allexcept(tbl,tbl[id]))