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
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 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