count number of rows in table

[AOD]

Hi All, 

Need help 

I have below table as source , I want to create a easure that gives me count of exact matched addresses, where there are multiple rows of exact same address. single row should not be considered.

Address	Type
11, XYZ Lane , Postcode :123	CT
11, XYZ Lane , Postcode :123	H
11, XYZ Lane , Postcode :123	R
5, XYZ Lane , Postcode :124	CT
5, XYZ Lane , Postcode :124	R
6, XYZ Lane , Postcode :32	CT
6, XYZ Land , Postcode :32	H
9, XYZ Lane , Postcode :12	CT

Example Measure -> Exact Match address should be 2 here , 

address 11, XYZ Lane , Postcode :123 and 5, XYZ Lane , Postcode :124 are exact match here with multiple rows. 

Can someone please help me in writing the measure?

Thanks in advance. 

[DataInsights · Accepted solution]

@AOD,

Try this measure:

Count Exact Match = 
VAR vTable =
    ADDCOLUMNS (
        VALUES ( 'Address'[Address] ),
        "@Count", CALCULATE ( COUNT ( 'Address'[Address] ) )
    )
VAR vResult =
    COUNTROWS ( FILTER ( vTable, [@Count] > 1 ) )
RETURN
    vResult