What DAX functions can be used to work with inactive relationships in Power BI?
Sahil Mehta
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!