Selectedvalue of relationship

[maserr]

Hi there,

I have a table that is using a field name "category" and a measure. This measure is behaving well because is using a USERELATIONSHIP inside its CALCULATE where it is activating the relationship that is not active. This way, there ara appearing "categories" that i do not have outside the relationship. When I click on a row of that table, the SELECTEDVALUE of the field "category" is blank. How can I obtain this field stored on a variable? This is because I have to pass it to a URL.

Hope I have explain more or less my situation,

Thanks in advance

[v-xiaotang]

Hi @maserr 

try to use the expression calculate(selectedvalue(xx),userelationship(xxx))  to replace with your expression selectedvalue(xx).

If problem still exists, could you kindly share PBI file after removing sensitive information or a sample file with simple data and structure? so that we can work on it quickly.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@maserr actually not fully clear what you are trying to achieve? You have a category slicer on the page but at the same time, you have a visual with the category and that visual has a measure that uses an inactive relationship? 

[parry2k]

@maserr not sure why that would be blank, it has nothing to do with the measure. Are you selecting more than one category?

[maserr]

No, I am selecting one row. The blanks is due to another slicer that is relation with an active relationship. In that case, I would need the active one not to interact and to active the other one.