Forum Discussion
DAX Formula to "Collect" multiple Rows
I'm trying to collect or summarize the status of tasks based on a person, but each task is a separate row. Here is an example of data: Name Task Name Status Bob Smith Task 1 Completed ...
Hi,
This measure works
Measure = COALESCE(minx(FILTER(SUMMARIZE(VALUES(Data[Task Name]),Data[Task Name],"ABCD",MAX(Data[Status])),[ABCD]="Pending"),Data[Task Name]),"Complete")