Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visual Filter error dues to inactive relationship

Hi Guys!

 

I have this measure that uses two different tables: [THA] comes form table [robotic data] and [primary hips] comes from [total sales by year] table. They both have column [region name], however that connection is inactive and I can't seem to activate it. I tried using USERELATIONSHIP function inside this measure to make the connection active but it didn't work, because the measure is not filtering on any regions. However, I need to add Regions as a filter on a visual and that's where the problem is becuase it's not calculating correctly becuase of that inactive connection. Please help!

 

THA mix = CALCULATE([THA],'Robotic data'[year]="2020")/([primary hips])

2 Replies

  • Anonymous , you should be able to create one active relation. If all relation is inactive, try to active one and check the error.

    It could be because bi-directional join. make some of them single direction and check

    • Anonymous's avatar
      Anonymous
      Not applicable

      I can't seem to make any direct active relationships between the two as it messes up the existing relationships between other tables and I don't want to deactivate them since they're used for other things