Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Denis_Slav
Helper III
Helper III

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.  

Denis_Slav_1-1612776551534.png

The diagramm of my model:

Denis_Slav_0-1612776442639.png

 

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

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.