Create a efficient data model to resolve the inactive relationship

[sivarajan21]

Hi,

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

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

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

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 

[sivarajan21]

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 · Accepted solution]

Hi @sivarajan21 ,

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

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

Best Regards

[sivarajan21]

Hi,

Thanks for your response!

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

Thanks

[sivarajan21]

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