Forum Discussion

android1's avatar
android1
Post Patron
7 years ago

Count if

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 the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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