Forum Discussion
Post ProdigyCreate a efficient data model to resolve the inactive relationship
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
Post ProdigyHi,
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