Advertised Brand Sales =
SUMX (
FILTER (
Sales,
CONTAINS (
'Advertised...Brands',
'Advertised Brands'[Brand], RELATED ( 'Product'[Brand] ),
'Advertised...下面的度量值执行了这个操作:
Advertised Brand Sales TreatAs =
VAR AdvertisedBrands =
SUMMARIZE (
'Advertised...Brands',
'Advertised Brands'[Brand],
'Advertised Brands'[Calendar Year],
'Advertised...Brands',
'Advertised Brands'[Brand],
'Advertised Brands'[Calendar Year],
'Advertised