Forum Discussion
Pivot Table Relationships and Multiple Responses
Thank you SergeiBaklan (and sorry for the delayed response, I had a 'post flooding' issue)
I can see that your example works and I think understand how but I'm not quite following why it's necessary.
The article you linked to (thank you) and reading around this suggests that that physical relationships are more reliable and refers to bi-directional filters, which look similar to what I started with (snip below). Is this approach not feasible here?
Yes, in general physical relationships are better. However,
- many-to-many (bi-directional) is not supported natively in Excel. As workaround here may generate measure with CROSSFILTER which imitates such behaviour
- in general bi-directional is not recommended, that could be negative side effects with it. If you can avoid it - better to avoid.
The only limitation could be performance. In most practical cases for Excel TREATAS works fine. If you don't have dozen millions of rows in the model we usually speak about milliseconds.
SergeiBaklan thank you so much, this has really helped me out
NeilMcLeod , you are welcome