Count if

[android1]

Hi,

Need to count the number of double up visits. This is where the ClientID is the same, the StaffID is not the same, the date is the same & the Start & End Times are the same. 

So in below there is 1 double up call. Need to show a count of 1.

[v-shex-msft]

Hi @android1,

You can use following measure to get count of rows of duplicate records.

Duplicate Count =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( Table ),
        [ClientID],
        [StartTime],
        [End Time],
        "Stuff Count", COUNT ( Table[Staff ID] )
    )
RETURN
    COUNTROWS ( FILTER ( summary, [Staff Count] > 1 ) )

Regards,

Xiaoxin Sheng