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

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