Forum Discussion
Calculated column has empty result for some records
I have added a Calculated Column in a Customers Table with this DAX formula: = VAR CustomerPurchase = FILTER('Sales', 'Sales'[CustomerNo] = CurrentCustomerID) VAR SortedPurchase = ADDCOLUMNS(C...
Hi johnt75 ,
Thanks for your reply. When I tried using your approach, I received this error:
The relationship between the Customer and Sales Tables is through the "CustomerNo" field in both tables.
johnt75
Super User
Super UserI've never come across that error before, but it sounds like a data quality issue. I would have a look at the customer no field in both tables and make sure that they match up correctly.