This content has been marked as final. Show 2 replies
Hello to All!
I want a measure that counts only Incident_Number where the number of ACT_Call_Incident_Relationship.Call_Request_ID is = 1.
I wrote in this way
Sum(If(Count([ACT_Call_Incident_Relationship.Call_Request_ID])=1 and Count(DISTINCT Incident_Number)=1,1,0))
But I get an error in the expression.
The result should be 2
Can someone help me with this matter?