Forum Discussion

ElMaldy's avatar
ElMaldy
New Member
3 years ago
Solved

Creating a new table with two calculated fields

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(TableTrai...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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.