Drilltrough from one table to another using timestamps

[AjansPF]

Hi everyone,

I have two tables of data - one is a call log where I have a user, a bunch of metrics and a timestamp for when the call starts.
I have a second table of actions taken by the user while on the call. User ID, Action and time of action. Each call should have mutliple actions associtated with it.

I want to click on a call and drill through (even filter would be fine at this point) to the list of actions performed during this call.

When I try to apply a greater than or equal to filter for the timestamp I get no results.

Any help is greatly appreciated.

[AjansPF]

There is not a call ID in both tables (see attached sample tables).
In both tables we have date/time and user ID, those would be the common keys.
I want to click on a calland see all a list of the actions that correspond with that call. User ID would be one key, and the data time as another.
Sorry I am unable to attach the PBIX file here

Call_ID	Start Time	User	End Time
1	2024-01-01 0:12	a1	2024-01-01 0:16
2	2024-01-01 2:32	a1	2024-01-01 2:33
3	2024-01-01 2:22	v1	2024-01-01 2:33

action	user	datetime
a	a1	2024-01-01 0:12
b	a1	2024-01-01 0:14
c	a1	2024-01-01 0:16
d	a1	2024-01-01 2:32
e	a1	2024-01-01 2:33
q	v1	2024-01-01 2:22
w	v1	2024-01-01 2:32
e	v1	2024-01-01 2:32
r	v1	2024-01-01 2:33

OUtput - Call	OUtput - User	Output - Action
1	a1	a
1	a1	b
1	a1	c

[amitchandak]

@AjansPF , Is there a column call ID, relating these two tables? Common dimension?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...