Creating a new table with two calculated fields

[ElMaldy]

Hi, I'm creating one new table, based on another table where I have activities and status (completed/not completed). I'm using this instruction to do that:
OpenTrainings = SUMMARIZECOLUMNS(TableTrainings[EmployeeID],TableTrainings[Chapter], FILTER(TableTrainings,TableTrainings[Completed]=FALSE()), "TotalOpen", COUNT(TableTrainings[ProcessID]))

It creates one table with the information of all the Open Processes BUT I want to add the closed processes, how can I do that?

EmployeeID	Chapter	TotalOpen
15	Chapter 01 - xxx activity	9
17	Chapter 01 - xxx activity	8
17	Chapter 02 - xxx activity	6

I would like to add the field: 

FILTER(TableTrainings,TableTrainings[Completed]=TRUE()), "TotalClosed", COUNT(TableTrainings[ProcessID])

but when I try to add to the same instruction, it fails.

Do I have to create another table even when the information is in the same table?

[v-jingzhang · Accepted solution]

Hi @ElMaldy 

You don't have to create another table. You can create a new table with below DAX. 

New Table = SUMMARIZECOLUMNS('TableTrainings'[EmployeeID],'TableTrainings'[Chapter],"TotalOpen",COUNTX(FILTER('TableTrainings','TableTrainings'[Completed]=FALSE()),'TableTrainings'[ProcessID]),"TotalClosed",COUNTX(FILTER('TableTrainings','TableTrainings'[Completed]=TRUE()),'TableTrainings'[ProcessID]))

And here is another option:

New Table = SUMMARIZE('TableTrainings','TableTrainings'[EmployeeID],'TableTrainings'[Chapter],"TotalOpen",CALCULATE(COUNT('TableTrainings'[ProcessID]),'TableTrainings'[Completed]=FALSE()),"TotalClosed",CALCULATE(COUNT('TableTrainings'[ProcessID]),'TableTrainings'[Completed]=TRUE()))

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.