locked
DAX Many to Many Relationship with an Inactive Relationship RRS feed

  • Question

  • I am hoping that some one has dealt with this issue before and I am running into a roadblock with my ineptitude. I have created a many to many relationship using Alberto Ferrari and Marco Russo's formula in dealing with m2m. However down the line I have an inactive relationship that based on the design of the db only works as inactive. When that relationship is active my m2m formula works just fine but when I add a userelationship function and inactivate the relationship, my calculate formula blows up.

    Let me know if you have dealt with this issue before and if you have how you solved the problem.

    Kind Regards in advance!

    The formulas used are as follows: 

    Registrant_Count=count(SEMINAR_REGISTRANTS[seminar_registrant_id])

    Registrant_Inactive=calculate([Registrant_Count],USERELATIONSHIP(SEMINAR_EVENTS[seminar_event_id],SEMINAR_SESSIONS[seminar_event_id]))

    Registrant=calculate([Registrant_Inactive],SEMINAR_REGISTRANTS,REGISTRANT_SESSIONS,SEMINAR_SESSIONS)

    Thursday, September 6, 2012 5:19 PM

Answers

  • John,

    USERELATIONSHIP has some really annoying bugs in DAX, did you install the latest cumulative update? It should be CU3. I don't remember well right now, but I think they have been resolved in the latest version. During my tests, I had several crashes due to m2m and USERELATIONSHIPS used together.


    Alberto Ferrari
    http://www.powerpivotworkshop.com

    Friday, September 7, 2012 2:35 PM