Forum Discussion
Post ProdigyCreate 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:
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
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
4 Replies
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
sivarajan21Hi Anonymous ,
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
- sivarajan21
Hi,
Thanks for your response!
As I didn't get any further response will this accept this as my solution.
Thanks
- 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 Anonymous