Forum Discussion

aflintdepm's avatar
aflintdepm
Icon for Helper III rankHelper III
3 years ago

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 ...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

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")