To work with inactive relationships in Power BI, you’ll want to use these DAX functions:
USERELATIONSHIP:
Activates an inactive relationship for the duration of a calculation.
Example:
CALCULATE(SUM(Sales[Amount]), USERELATIONSHIP(Sales[Date], Calendar[Date]))CROSSFILTER:
Controls the direction of a relationship (both active and inactive).
Example:
CALCULATE(SUM(Sales[Amount]), CROSSFILTER(Sales[Date], Calendar[Date], BOTH))TREATAS:
Allows you to create virtual relationships between tables, even without a physical relationship.
Example:
CALCULATE(
SUM(Sales[Amount]), q TREATAS(VALUES(Calendar[Date]), Sales[Date]))
Hope this answers the question!