I have the need to report on operational accuracy of our delivery team. The goal is to analyze our shipment data and compare the actual shipping warehouse to the default shipping warehouse of the customer location. My model consists or a fact table with shipment information, Links to CustomerDim, DateDim, and WarehouseDim. In the CustomerDim I store the default shippping warehouse. I want to compare Actual Shipping warehouse to the Customer Default Shipping warehouse to see if they match. I am trying to add a column to the shipment fact table display true/false or 1/0 if the shipment originated from the proper warehouse. I have not found a way to say if WarehouseDim[Warehouse] = CustomerDim[Default Warehouse] then true else false. The simple if statement says cant find WarehouseDim. So I tried Values(WarehouseDim[Warehouse]) = Values(CustomerDim[Default Warehouse]), then I get no error on the formula but when I try to use the calculated field in a visual I get "A table of multiple values was supplied where a single value was expected.". Any ideas you can share on how to accomplish this task is greatly appreciated.
