Bridge Table

[ramiro_gonzalez]

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?

[ramiro_gonzalez]

Many thanks! It works!

[Daniel29195 · Accepted solution]

@ramiro_gonzalez 

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! 🤠