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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

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 @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.


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

Not applicable

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.