Create percentage of tasks

[Barrie2020]

Hello

I currently have a table like below

Username	TaskID	TaskCompleted
usera	1234	y
usera	1235	n
userb	1236	y
userb	1237	y
userb	1238	y

Taskid is a taskid number of each task assigned to the user

Task completed is either y or n if they have / have not completed the task

I am trying to get an output that will show the username like below, how many tasks overall have been assigned, separated by how many have been completed / not completed and the percentage

I have tried to create a filter column to show number of tasks completed and number of tasks not completed however only 1 filter appears to work as it changes the result

Username	CountofTaskID	NumberTasksNotCompleted	NumberTasksCompleted	Percentage completed
usera	2	1	1	50
userb	3	0	3	100

Sorry for any confusion

Hope this makes sense

[parry2k · Accepted solution]

@Barrie2020 add following measures and use this in visualization.

Total Tasks = COUNTROWS ( Table )

Tasks Completed = CALCULATE ( [Total Tasks], Table[TaskCompleted] = "Y" )


Tasks Pending = CALCULATE ( [Total Tasks], Table[TaskCompleted] = "N" )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[parry2k · Accepted solution]

@Barrie2020 add following measures and use this in visualization.

Total Tasks = COUNTROWS ( Table )

Tasks Completed = CALCULATE ( [Total Tasks], Table[TaskCompleted] = "Y" )


Tasks Pending = CALCULATE ( [Total Tasks], Table[TaskCompleted] = "N" )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Barrie2020]

Hi @parry2k 

Thanks for your quick response

This works a treat!

I now need to work out how to do a percentage of those completed from  Table[TaskCompleted] = "Y" against Total Tasks = COUNTROWS ( Table )

Thanks again!

[parry2k · Accepted solution]

@Barrie2020 another measure

% Completed = DIVIDE ( [Tasks Completed], [Total Tasks] )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Barrie2020]

@parry2k 

Superstar!

this works as expected

Thanks again for this, Stay Safe!