Dynamic distinctcount using a variable data

anne-sophie,

Try this measure. No relationship exists between the two tables.

Distinct Product Count =
VAR vYear =
    MAX ( Years[Year] )
VAR vStartDate =
    DATE ( vYear, 1, 1 )
VAR vProductRows =
    FILTER (
        Products,
        vStartDate >= Products[FirstRelease]
            && (
                vStartDate <= Products[EndOfProduct]
                    || ISBLANK ( Products[EndOfProduct] )
            )
    )
VAR vResult =
    CALCULATE ( DISTINCTCOUNT ( Products[ProductCode] ), vProductRows )
RETURN
    vResult