Forum Discussion
Wrong Filter Flow Direction when using Excel Power Pivot
As variant you may add measure
Count Arena:=CALCULATE(
COUNTROWS(Arena),
CROSSFILTER(Arena[ArenaCode],Arena_Package[ArenaCode],Both)
)Result is
Grand Total is 5 since totally it's 5 different arenas appeared. In general depends on what do you need if modify.
Thank you Sergei!
I will ask you the same thing I asked Riny. In Power BI, you can set the filter direction to bi-directional but that does not seem to be the case in Excel Power Pivot? Eventually, I want to build a bigger model but I am unsure if that will work in Excel if the filtering direction only goes one way. Do you have any experience regarding this?
No, bi-directional is not supported in Power Pivot. CROSSFILTER() works instead, but you shall add it to each measure which uses such relationships.
In general it's better to avoid bi-directional even in Power BI since decreases the performance, but it very depends on the model is that critical or not.
- Thanks for your time and input Sergei!
Robin_Lindstrom , glad to help