DAX Measure: check each row in a data subset for a specific value
I try to check for each row if a DAX measure is <0. However, the check shall be done for each ID separately and not for the whole column. If TRUE, all rows related to this specific ID shall use measure2. If all rows within an ID are positive measure1 shall be used