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.
SergeiBaklan That is true, but Power Pivot lacks the ability to filter slicers based on Measure Filters, which is the best way to avoid Bi-Di in Power BI.
The answer to Bi-Di is rarely, but it isn't never.
I hate to see Power Pivot getting stale like this. Bi-Di is just the tip of the iceberg. I'd kill for ISINSCOPE() vs having to fool with HASONEFILTER/HASONEVALUE trickery to keep/suppress totals and such.
