Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
please find the below error screen shot
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
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.
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
tired but once i click activate button ok button diabled
i have the same issue
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |