Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Measure evaulation context issue with related table

Hi all, I'm having an issue with a Measure when I introduce data from a related table, so let me explain (the second time, after losing my first post):   I have a Usage table with usernames and tot...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello all,

     

    I think, after building a "clean" test model I've discovered the issue at hand. I have a many-to-many relationship which is causing the issue I'm seeing. My clean model has only many-to-single relationships. This would seem to make sense to me based on what I'm seeing. Based on what I've described does this make sense to everyone?

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

Yup. In general many-to-many should be avoided unless you know exactly how it will work and there is no other way. Glad you found the issue and were able to get it to a one-to-many relationship.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

if only it were that simple... my "clean" model was for the purposes of troubleshooting and to post here. The real model retains the many to many and I know why it's there and what the underlying issues are, but "fixing" it becomes its own project unto itself. This was just a fall on effect that I didn't recgonize right away.

 

Joy...

 

Thanks all!