INTERSECT (avant Fév. 2017)

[Filtered Measure] :=
CALCULATE (
    <target_measure>,
    INTERSECT (
        ALL ( <target_granularity_column> ),
        VALUES ( <lookup_granularity_column> )
    )
)

CALCULATE (
    [Sales Amount],
    INTERSECT (
        CROSSJOIN (
            ALL ( 'Product'[Category] ),
            ALL ( 'Date'[Calendar Year Number] )
        )
        SUMMARIZE ( Promotion, Promotion [Category], Promotion[Year] )
    )
)