Support Formation DAX

Share

Explore

Support Formation DAX

Sans relation dans le modèle

INTERSECT (avant Fév. 2017)

[Filtered Measure] :=

CALCULATE (

<target_measure>,

INTERSECT (

ALL ( <target_granularity_column> ),

VALUES ( <lookup_granularity_column> )

)

)

Exemple "Promotion” :

CALCULATE (

[Sales Amount],

INTERSECT (

CROSSJOIN (

ALL ( 'Product'[Category] ),

ALL ( 'Date'[Calendar Year Number] )

)

SUMMARIZE ( Promotion, Promotion [Category], Promotion[Year] )

)

)

Share

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.