Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.