Forum Discussion
Does someone know if bi-directional cross-filtering will appear in Power Pivot?
That's an issue but not showstopper, CROSSFILTER() works.
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.Another point is negative impact on performance.
But yes, of course, there is no such things which never to use, or ones which only to use. Depends on data characteristics and model.
I don't think Power Pivot ever will be full scale tool. But perhaps that's not critical these days, at least for corporate environment.
