Need help with DAX to get unique occurence record counts in table

[Anonymous]

Hi ,

Need help with DAX measure and scnario as follows-

From_ID	Conversation_ID	CID	Concat(From_ID,Conversation_ID)
San	CON1	1	San_CON1
San	CON1	2	San_CON1
San	CON1	3	San_CON1
Sea	CON2	1	Sea_CON2
Sea	CON3	1	Sea_CON3
Sea	CON4	1	Sea_CON4
Sub	CON5	1	Sub_CON5
Sub	CON6	1	Sub_CON6
Ram	CON66	1	Ram_CON66
Ran	CON666	1	Ran_CON666

expected Out put

Unique Records Count - 3 (distinct count of From_ID where distinct count(Concat) = 1)

Duplicate Recrd count - 2 (distinct count of From_ID where distinct count(Concat) > 1)

Please help with DAX query

[amitchandak · Accepted solution]

@Anonymous , Try measures like

countx(filter(summarize(Table, table[From_ID], "_1", distinctcount(Table[Concat])), [_1] =1),[From_ID])

countx(filter(summarize(Table, table[From_ID], "_1", distinctcount(Table[Concat])), [_1] >1),[From_ID])

[Anonymous]

Thanks a lot Amit the measure worked perfectly and one great learning on usage of summary function in COUNTX.