undefined

Lakshmi20 — Sun, 19 Feb 2023 07:04:01 GMT

Hi friends,

How to convert an active relationship to inactive relationship?

Using any dax

Re: undefined

FreemanZ — Sun, 19 Feb 2023 08:15:20 GMT

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.