1
Reply

What DAX functions can be used to work with inactive relationships in Power BI?

Sahil Mehta

Sahil Mehta

Jan 22
114
0
Reply

    To work with inactive relationships in Power BI, you’ll want to use these DAX functions:

    1. USERELATIONSHIP:

      Activates an inactive relationship for the duration of a calculation.

      Example:
      CALCULATE(SUM(Sales[Amount]), USERELATIONSHIP(Sales[Date], Calendar[Date]))

    2. CROSSFILTER:

      Controls the direction of a relationship (both active and inactive).

      Example:
      CALCULATE(SUM(Sales[Amount]), CROSSFILTER(Sales[Date], Calendar[Date], BOTH))

    3. 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!