Matching records

[setis]

Dear all,

I have a telephone book that looks like this:

I am trying to calculate the not answered calls. This is, calls that have been placed in queue but do not have a "descript" = conversation. 

Any idea on how to approach this?

thank you in advance!

[amitchandak · Accepted solution]

Something like this

sumx(filter(summarize(table, table[Call id], "_q",calculate(count(table[Call id]),Table[descript] = "placed in queue")
		, "_c",calculate(count(table[Call id]),Table[descript] = "conversation")), [_q]>0 && ([_c] =0 || isblank([_c]))),[_q])