What are many-to-many relationships and how can they be addressed in Power BI?
Many to Many relationships involve a bridge or junction table reflecting the combinations of two dimensions (e.g. doctors and patients). Either all possible combinations or those combinations that have occurred.
* Bi-Directional Crossfiltering relationships can be used in PBIX.
* CROSSFILTER function can be used in Power Pivot for Excel.
* DAX can be used per metric to check and optionally modify the filter context.
