在 2008 年和 2009 年都购买过手机类别产品的客户列表:
EVALUATE
CALCULATETABLE (VALUES ( Customer[Customer Code] ),INTERSECT (CALCULATETABLE (SUMMARIZE (Sales,Customer[CustomerKey],Product[ProductKey]),'Date'[Calendar Year Number] = 2008,'Product Category'[Category] = "Cell phones"),CALCULATETABLE (SUMMARIZE (Sales,Customer[CustomerKey],Product[ProductKey]),'Date'[Calendar Year Number] = 2009,'Product Category'[Category] = "Cell phones"))
)