Forum Discussion
Solved
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]),...
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!