Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Filter Table A then filter Table B then filter Table A

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:
from EVENTS (3)
where LEADID in (LEAD ID selected in the EVENTS TABLE (1)).
I hope i was clear.
Thank you very much.



Super User
Super User

Hi @virtualdelo ,


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.


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Trying to resolve my request i open another post here with more details:

Here the file:
link of excel data and pbix of a seample.

Thanks 4 your support!

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.