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
Example
I tried to combine different DAX functions, like filter, if, etc. but didn´t get the job done.
New contributor
Marcus is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.