Forum Discussion
Bridge Table
Hi everyone and thank yuo in advance for your wisdom!
I'm trying to create a calculated column in one table (Table A) using a bridge table as a filter,
CALCULATE(DISTINCTCOUNT(Table A [Email]), 'Bridge Table'),
so that it gives me, for each email in Table A, the total different emails in Table B. However, it only gives me the total emails in Table B, as if there were no relationship with the bridge table. Do you know why this might be?
when using a bridge table , you need always to activate a bi directional filter .
activate a bi directional filter between a table and the bridge.
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
https://www.youtube.com/watch?v=dEgBOsQGHBA&t=693s
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
2 Replies
when using a bridge table , you need always to activate a bi directional filter .
activate a bi directional filter between a table and the bridge.
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
https://www.youtube.com/watch?v=dEgBOsQGHBA&t=693s
hope this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠Many thanks! It works!
