I am not sure what the end result should look like, but I think you should be able to at least get what you need using an aggregated data source and a join. Please keep in mind that this approach creates temporary tables in memory and can consume resources, so may not be appropriate if your data are large or if you have a large number of concurrent users. Here are some steps I took to get the results and assumes you can change the input data slightly:
1. Create a new variable in your source data that concatenates RESPONSE and CLAIM_ID (I called this RESPONSE_CLAIM)
2. Once this has been added to your source table and reloaded, create a new measure (I called this REPONSE_COUNT) with logic similar to below:
IF ( Substring('Response_Claim'n, 1, 3) = 'Tri' ) RETURN 1 ELSE 0
3. Create an aggregated data source using the concatenated data item and the calculated measure from above (RESPONSE_COUNT)
4. Join your original table with the aggregated data source using a left join with RESPONSE_CLAIM being the key and selecting the columns you would like to use.
Again, I am not sure what your desired outcome is and this may need some tweaking, but the screenshot below shows a table showing the number of triggered alerts for claims. This table filters the lower table that contains detail records so that clicking on the top table shows details for that claim.
Hope this helps!
... View more