Forum Discussion
Need help modelling
Hi, I have searched the other answers, but I'm still stuck/ don't see the big picture. I know HOW to pivot, merge, append - but don't know WHEN/IF. I have answers to survey questions from co...
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
For performance reasons it is better that you reduce BD relationships.It is recommend that you activate bi-directional filtering in a measure definition by using the CROSSFILTER DAX function instead. Maybe you can consider using the bridge table as a slicer.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.