DAX
Share
Explore
DAX
Sans relation dans le modèle

icon picker
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] )
)
)
Gallery
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.