Fetches measurement options for products to be used in dropdowns and other UI components. Returns lightweight data with measurement and product information. Supports filtering by product ID. Handles both new data (with measurement_id) and legacy data (using item_category_id + m_metric).