79756418

Date: 2025-09-05 05:15:27
Score: 1.5
Natty:
Report link

Thanks for the join suggestion. I did write a measure to find the corresponding record in the Customers table and it returned 170. Here is the measure:

Orders with no customer = calculate(DISTINCTCOUNT('Sales Data 2022'[OrderNumber]), filter('Sales Data 2022', isblank(RELATED('Customer Lookup'[CustomerKey]))))
Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Laxmiprasad Iyer