Filter Table A then filter Table B then filter Table A

[Anonymous]

Hi everyone,

and thanks for all the support.

I post my schema: a table LeadsId and Events are connected with the relation one to many on the filed leadid. There is also the user dimension.

On my page i have in the first table Events (1) for username a measure that count the nr. leads (DISTINCTCOUNT) touched, and this it's ok.
I need to have a table (3) with a measure that counts all the events for all the users of particular lead id selected in the table (1).
Now i use a workaround passing by a table leads (2) that rapresent the leads id selected in the first table (1) i have to select one to one the leads that i need and then expose the measure in the Table (3).
The table (1) doesn't filter the table (3).
There is a way to write a measure that filter the table events by the lead id selected in the first table (events)?
Something like this sql query:
Select EVENTS ID
from EVENTS (3)
where LEADID in (LEAD ID selected in the EVENTS TABLE (1)).
I hope i was clear.
Thank you very much.

[MFelix]

Hi @Anonymous ,

I believe I understand your issue however without any data is difficult to give you the correct answers, especcially since I see you have several relationships and one of them is a bidirectional.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[Anonymous]

Trying to resolve my request i open another post here with more details:
https://community.powerbi.com/t5/Desktop/Filter-a-Table-by-the-values-returned-by-another-table/m-p/...

Here the file:
https://we.tl/t-DGGCsgKa3n
link of excel data and pbix of a seample.

Thanks 4 your support!