Forum Discussion
Power Pivot Related table not providing the correct results
Obviously USERELATIONSHIP is straightforward and better than CROSSFILTER where you know what you are doing. CROSSFILTER has some drawbacks unless you know how the filter context is being evaluated in your Pivot Table.
Though in your case both the methods produce the same output, I would prefer USERELATIONSHIP over CROSSFILTER.
Thank you, that works!
Before I received your answer, I tried this solution as well, it provides the same results, please look in the file attached.
Which way is better 🙂 ?
Kind Regards,
Robin
Obviously USERELATIONSHIP is straightforward and better than CROSSFILTER where you know what you are doing. CROSSFILTER has some drawbacks unless you know how the filter context is being evaluated in your Pivot Table.
Though in your case both the methods produce the same output, I would prefer USERELATIONSHIP over CROSSFILTER.
- Thanks a lot! Really appeciate it!
- You're welcome Robin_Lindstrom!