Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.