Forum Discussion

darshaningale's avatar
darshaningale
Resolver II
5 years ago
Solved

How to Filter table data based on USERELATIONSHIP

I have table A and table B. There is no active relationship between both of them. I have created two measures in Table A based on USERELATIONSHIP between Table A & Table B. I have put both the meas...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi darshaningale,

    I think you are misunderstood with USERELATIONSHIP functions.

    Power bi not able to dynamically change the active relationship based on selection. (this function does not change the active relationship)
    It will change the DAX expressions filters to use an inactive relationship key to filter on your expression and not affect the current relationship and filter interaction of visuals.
    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi darshaningale,

I think you are misunderstood with USERELATIONSHIP functions.

Power bi not able to dynamically change the active relationship based on selection. (this function does not change the active relationship)
It will change the DAX expressions filters to use an inactive relationship key to filter on your expression and not affect the current relationship and filter interaction of visuals.
Regards,

Xiaoxin Sheng