DAX Formula to "Collect" multiple Rows

[aflintdepm]

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
Bob Smith	Task 2	Pending
Jane Doe	Task 1	Pending
John Jones	Task 1	Completed
John Jones	Task 2	Completed

What I would like is a formula that says - For [Name], if any Task is Pending, then "Task Name", otherwise "Complete"

So, my desired results would look like this:

Bob Smith | "Task 2"

Jane Doe | "Task 1"

John Jones | "Complete"

Any examples or tutorial references would be appreciated.

[Ahmedx]

pls try this

---

Measure 1 =
COALESCE(
CALCULATE(MAX('Table'[Task Name]), 
CONTAINSSTRING("Pending",'Table'[Status])),"Completed")

------- or-----------
Measure 2 = 
CALCULATE(SELECTEDVALUE('Table'[TaskName],"Completed"),
             CONTAINSSTRING("Pending",'Table'[Status]))

[Ashish_Mathur]

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