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
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

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