Many-To-Many Relationship Modelling in PowerPivot: Workaround
So far PowerPivot does not support many to many relationships. It is still early days and I am sure that things will change soon. Moreover, there are a few ways to implement many-to-many relationships for measures in DAX. Two notable posts on the subject can be found on Marco Russo's and Alberto Ferrari's blogs:
Read more...
Tags: many-to-many, design