How to make make inactive relationship to active

[Anonymous]

i have Four tables Month and TWT-PL ,PL,MX .   PL and MX both  table have fileds tobacco weight and month . i am trying to make realtioship but  getting  inactive mode 

TWT-PL (Tobacco weight target)  -  MX (Tobacco weight target)

TWT-PL(Tobacco weight target)   -   PL(Tobacco weight target)

Month Filter (Month) - > PL(Month)

Month Filter(Month) - > MX(Month)

 only few relationship  will be active . i want to make all relationship  active . i am trying USERELATIONSHIP measure but not wokring . any Idea 

[Radhika2605]

Are these relationships bi-directional?  Make them single direction (1:many) and it should work.

If you still can't activate the relatioship then is it throwing some error ? Can you please check and send a screenshot of the error?

If doing above still doesn't work them the only option left is ti use DAX functions like you used. Can you please send me your userelationship measure as to how you are using it, it could be something wrong in the formula which might be causing issue.

Thanks

Radhika

[Anonymous]

please find the below error screen shot 

Measure FOR Mx = SELECTCOLUMNS('MX(CIGATAM)',"Tobbaco weight",[Tobacco Weight Target])

Measure for INACTIVE values = CALCULATE([Measure FOR Mx],USERELATIONSHIP('MX(CIGATAM)'[Tobacco Weight Target],'TWT -MX'[Tobacco Weight target])

)

i have updated with measure also .

[Radhika2605]

Hi, 

This measure looks fine to me. Are you expecting that the relationship which you have created using this measure will change the relationship from Inactive to Active in model. If so then this is not the case. What this measure does is that when there is an inactive relationship but if you still want to create relation for some calculation then you can use this USERELATIONSHIP function which creates a relation using DAX (not in the model but on the back end for calculation purpose only).

Essentially, USERELATIONSHIP function specifies the relationship to be used in a specific calculation as the one that exists between columnName1 and columnName2. It will not convert the relationships in model.

Hope this clarifies.

Thanks

Radhika

[Radhika2605]

Hi,

You can right click on the relationship icon (shown in red in screenshot) and choose Properties and in the pop there will a option in the end to activate relationship.

Mark it as a solution if I answered your question.

[Radhika2605]

Apologies the second screenshot didnt load, 

Once you click on Properties then this pop will show and you can activate relationshio.

Mark it as a solution if I answered your question.

Thanks

Radhika

[Anonymous]

tired  but once i click activate button ok button diabled 

[Anonymous]

i have the same issue