Get count of duplicate users to card visual in live connection

[Anonymous]

Hi,

I am using live connection and my sample data looks like this

ID    Name

1      Pratap

2      Pratap

3      Raj

4      Raj

5      Harini

expected out put: in card visual

Repeated users:   2

can you please help me

[SpartaBI · Accepted solution]

@Anonymous 

Measure = 
    COUNTROWS(
        FILTER(
            VALUES('Table'[Name]),
            CALCULATE(COUNTROWS('Table') > 1)
        )
    )

Showcase Report – Contoso By SpartaBI