Companion contentInsert your email address and press Download for access to the files used in this book.
To ensure the ongoing accuracy of this book and its companion content, we have reviewed and confirmed the errors listed below. If you find a new oversight, please report it to us.
Page 406: Inequality operator in sample code
The code has a inequality operator (<>) instead of greater than (>) at line 11:
BoughtProduct := CALCULATE ( COUNTROWS ( DimCustomer ), CALCULATETABLE ( FILTER ( DimCustomer, AND ( CALCULATE ( COUNTROWS ( FactInternetSales ), USERELATIONSHIP ( FactInternetSales[ProductKey], ProductBought[ProductKey] ) ) <> 0, CALCULATE ( COUNTROWS ( FactInternetSales ), USERELATIONSHIP ( FactInternetSales[ProductKey], ProductToCheck[ProductKey] ) ) ) = 0 ) ), FILTER ( ALL ( DimDate ), DimDate[FullDateAlternateKey] < MAX ( DimDate[FullDateAlternateKey] ) ) )