Forum Discussion

vasathi's avatar
vasathi
Helper II
5 years ago

Relationship for multi company data

Team, I have problem with Relationship. Basically i need the following. In my Datamodel having multiple companies and each companies having their own masters How to make the relationship to filer...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi vasathi 

There can only be one active filter propagation path between two model tables. For more, pls see

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#make-this-relationship-active

here's an animated example showing how relationships propagate filters,

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#relationship-purpose

-

you can use the USERELATIONSHIP DAX function, which activates filter propagation for a specific relationship only during the evaluation of the expression.

about how to use USERELATIONSHIP, here's an example, see https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive#inactive-relationships

 

For more information, pls read,

https://docs.microsoft.com/en-us/dax/userelationship-function-dax

https://www.youtube.com/watch?v=X9rkpt7-LNQ

 

if problem still persists or more tutorials needed, please let me know.

 

 

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.

vasathi's avatar
vasathi
Helper II
5 years ago

Thanks, But these are all i have checked before but no use.

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    thanks for your reply vasathi 

    but tutorials I attached above are all trying to explain that, why the other relationships are inactive.

    and if you want to use inactive relationship, pls read tutorial about function  USERELATIONSHIP ðŸ¤£

     

    -

     

    Have you solved your problem? If yes, kindly accept the answer helpful as the solution. so the others can find it more quickly.

    Or

    if problem still persists, please let me know.

     

    Best Regards,

    Community Support Team _ Tang