Forum Discussion

Denis_Slav's avatar
Denis_Slav
Helper III
5 years ago
Solved

Create filter for multiple tables

Hi Community, 

I try to create universal filter of (TRUE/FALSE) for multiple tables. But PBI don't allow make active relationship for them.  

The diagramm of my model:

 

Is there way to make them active, or it better change the measures?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Denis_Slav,

    AFAIK, current power bi does not allow you to activate multiple major relationships to link tables.

    I'd like to suggest you take a look at the following links about power bi star schema relationship design and the AS tabular model relationship build document to know more about these:

    Understand star schema and the importance for Power BI 

    Relationships in analysis services tabular models 

    FOr these inactive relationships, you can try to use the Dax function 'userelationship' to calculate with particular relationship keys.

    DAX 101: Using USERELATIONSHIP in DAX 

    Regards,

    Xiaoxin Sheng

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Denis_Slav , Make sure there are no two paths created to this table. left most tables can reach right most table via two path. Top in second row and middle in second row. That is not allowed. 

     

    Table A to Table B , there should only one path , even in there are tables in between