Count list of records which have different RC cycles - in Measure

[RanjeetK]

Hi , 
I need help on this topic - 

in Above table we have ID and etach ID have activity ID which is unique - and they fall in one Bucket (RC Cycles)
i need to count a list of records which have two RC cycles 
Output

thanks in advance 🙂 !!
https://community.powerbi.com/t5/Desktop/DAX-Count-the-number-of-values-that-appear-more-than-once-i... 

[amitchandak]

@RanjeetK ,

New measure =

var _cnt = calculate(countdistinct(Table[Activity Rc Cycle]), filter(allselected(Table), Table[Audit ID] = max(Table[ID])) )

return

sumx(filter(Values(Table[Audit ID]), _cnt>=2) , _cnt)

[RanjeetK]

@amitchandak , thanks for reply!!
Table[Audit ID] = max(Table[ID])
MAX(table[ID]) ------ ?? - what should i put
i take - Table[Audit ID] - it returns following records which are not correct
let me know

Main Table

Audit ID	Activity ID	Activity RC Cycle
100	101	4
100	102	4
100	103	4
100	104	1
1000	105	5
1000	106	5
1000	107	5
10000	108	6
10000	109	6
10000	110	5