Forum Discussion

Lakshmi20's avatar
Lakshmi20
New Member
3 years ago

undefined

Hi friends, 

How to convert an active relationship to inactive relationship? 

Using any dax

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Lakshmi20 

     

    use CROSSFILTER() in your CALCULATE codes.

     

    for example:

    the data model:

    dataset:

     

    1) write two measures:

     

    SalesMeasure = SUM(Sales[Sales])

SalesMeasureCrossFilterNone = 
CALCULATE(
    SUM(Sales[Sales]),
    CROSSFILTER('Product'[Product],Sales[Product],None)
)

     

     

    2) plot a table with two measure and the Product column from Product Table

    you see, the relationship is inactive.