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