Forum Discussion
Solved
Power Pivot Related table not providing the correct results
Hi guys, I am in need of some serious help. I am trying to get the related values from the "Test 2" table regarding Total Number of Contacts for the specific dates. Instead of showing the cor...
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.
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!