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 there is 1 double up call. Need to show a count of 1.

 

Need Help

1 Reply

  • 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