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.
| Incident_Number | Call_Request_ID |
| Inc001 | Call_re01 |
| Inc001 | Call_re02 |
| Inc001 | Call_re03 |
| Inc002 | Call_re04 |
| Inc003 | Call_re05 |
| Inc003 | Call_re06 |
| Inc004 | Call_re07 |
| Inc004 | Call_re08 |
| Inc005 | Call_re09 |
The result should be 2
Can someone help me with this matter?
