Forum Discussion

RanjeetK's avatar
RanjeetK
Helper I
3 years ago
Solved

Count Duplicate records with multiple columns

Hello , i need help to solve following problem. i need count of Audit ID which are having duplicate records. Like every audit ID have a different Activity key but some of them are repeated  EX :- 1...
Need Help
  • RanjeetK's avatar
    RanjeetK
    3 years ago

    Hey Hi All ,
    I got solution 

    Var _Count = ADDCOLUMNS(SUMMARIZE(data,data[Audit ID],data[Activity ID],data[Activity RC Cycle]),
    "@Count",CALCULATE(COUNTA(data[Activity RC Cycle]),ALLSELECTED(data[Audit ID]))
    )

    Var _Greaterthan = FILTER(_Count,[@Count]>=2)
    Var _Result = COUNTROWS(_Greaterthan)
    RETURN
    _Result


     

     

RanjeetK's avatar
RanjeetK
Helper I
3 years ago

@Mikelytics , Thanks for your efforts 
but it does not work , i have tried it in my data as you can see 

Measure 2 = SUMX(
                 VALUES(data[Activity ID]),
                 Var Var_All = CALCULATE(
                                         COUNTROWS(data),
                                         ALLEXCEPT(data,data[Activity ID])
                                        )
                                  Return
                                  IF(Var_All>1,Var_All-1,BLANK()
                                  ))
It returns Blank 

Please share your file if possible and thanks for immediate reply