Forum Discussion
Does someone know if bi-directional cross-filtering will appear in Power Pivot?
Like in SSAS 2016 and Power BI desktop. Thanks
2021 and this is still an issue.
That's an issue but not showstopper, CROSSFILTER() works.
- So I need to create a DAX measure for every possible measure I want to crossfilter? No thanks. I'll do it someplace other than excel instead.
Depends on goals and on model. In general it's better to avoid bi-directional where possible. For example Bidirectional relationships and ambiguity in DAX - SQLBI and some other recommendations.
