Help with measure (unrelated tables) to find outbound calls from another table of inbound calls

[rjs2]

Sorry for the lengthy title, couldnt think of a better one.

I have a table with inbound calls that left voicemail messages and another table of outbound calls.

I am trying to write a measure that will filter outbound call table:

 - by the number in the inbound call table

 - then filter it bassed on dates greater than the inbound call but less than the next inbound call for the same number (if there is one)

 - to get how many return calls there were that can be associated with the inbound call.

I am still a rookie, but I was thinking I would need to set up a varaible tables, but I am still learning more complex dax.

I hope I explained that correctly

[rjs2]

still looking for help on this

[v-henryk-mstf]

Hi @rjs2 ,

Need some test data (delete sensitive information) and the desired expected results. So I can answer for you.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Henry

[rjs2]

hard to send test data, since we are dealing with phone numbers.

[v-henryk-mstf]

Hi @rjs2 ,

You can show a screenshot of the results you expect to get by plotting them for my further testing. Looking forward to your reply.

Best Regards,
Henry