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
sivarajan21
Post Patron
Post Patron

Create a efficient data model to resolve the inactive relationship

Hi,

 

I have tables that am finding it difficult to create efficient modeling. The below is the model that we created:

sivarajan21_0-1694159018109.png

 

Although this is created, the one highlighted in red are inactive relationships. When I am trying to make them active, am getting below error:

sivarajan21_1-1694159110167.png

My output model should be in such a way that columns in communication table can be filtered by below tables.

sivarajan21_2-1694159241958.png

As there are inactive relationship, I am afraid to create dax and slicers which may not work because of these inactive relationships.

Please can you suggest some efficient ways to create relationships between tables?

Please let me know if you need further info!

 

PFA file Communications (2).pbix

 

Thanks in advance

 

@Ahmedx @Greg_Deckler @amitchandak @grantsamborn @Ashish_Mathur 

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

Hi @sivarajan21 ,

It seems that the shared file no longer exist, could you please share it again? Thank you.

vyiruanmsft_0-1694428275319.png

About how to deal with the inactive relationship, you can refer the following links to get it.

Active vs inactive relationship guidance - Power BI | Microsoft Learn

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI - RADACAD

Sales by Ship Date = CALCULATE(
SUM(FactInternetSales[SalesAmount]),
USERELATIONSHIP(
FactInternetSales[ShipDateKey],
DimDate[DateKey]
)
)

Manage inactive relationships with USERELATIONSHIP in Power BI – Curbal

vyiruanmsft_1-1694428992757.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
sivarajan21
Post Patron
Post Patron

Hi,

 

Is there any way we can make these inactive relationships to active? I don't want to remove the relationship between these tables, because all these tables have a connection to Communication table, so we need to filter communication from all tables.

 

Please need your help on this!

 

Thanks in advance!

@Ahmedx @Greg_Deckler @Ashish_Mathur @amitchandak @v-yiruan-msft 

v-yiruan-msft
Community Support
Community Support

Hi @sivarajan21 ,

It seems that the shared file no longer exist, could you please share it again? Thank you.

vyiruanmsft_0-1694428275319.png

About how to deal with the inactive relationship, you can refer the following links to get it.

Active vs inactive relationship guidance - Power BI | Microsoft Learn

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI - RADACAD

Sales by Ship Date = CALCULATE(
SUM(FactInternetSales[SalesAmount]),
USERELATIONSHIP(
FactInternetSales[ShipDateKey],
DimDate[DateKey]
)
)

Manage inactive relationships with USERELATIONSHIP in Power BI – Curbal

vyiruanmsft_1-1694428992757.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

Thanks for your response!

As I didn't get any further response will this accept this as my solution.

Thanks

Hi @v-yiruan-msft ,

 

Many thanks for your response!😊

Apologise for removing the file, PFA shared file here Communications (2).pbix

Awesome articles on inactive relationships. I am struggling to apply these on my modeling.

 

Could you please help me how to build a better model in my sample file above?

 

Thanks in advance

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.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors