Create filter for multiple tables

[Denis_Slav]

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?

[Anonymous · Accepted solution]

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]

@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