Forum Discussion
Represent Late Task Counts
I was hoping to represent the late task count in something like a gauge visual. I want to show the amount of late tasks remaining out of all tasks and another version out of all remaining incomplete tasks. Any help or suggestions would be greatly appreciated!
Thank you Kishore_KVN
Hi, AllisonGis
Based on the sample data you provide:
Start by creating a measure that calculates the total number of tasks:
Alltaks = COUNTROWS('Table')Second, create a metric that counts the tasks with status=Late:
LateTask = COUNTROWS(FILTER('Table','Table'[Status]="Late"))Use these two measures in the Gauge visual:
I have provided the PBIX used this time below for your reference.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Thank you Kishore_KVN
Hi, AllisonGis
Based on the sample data you provide:
Start by creating a measure that calculates the total number of tasks:
Alltaks = COUNTROWS('Table')Second, create a metric that counts the tasks with status=Late:
LateTask = COUNTROWS(FILTER('Table','Table'[Status]="Late"))Use these two measures in the Gauge visual:
I have provided the PBIX used this time below for your reference.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous,
Thank you so much for your help this is exactly what I was looking for!
Hello can you please elaborate the requirement. It is bit confusing. But if you want late percentage out of all tasks then you can use below Measure.
Late Percentage = VAR LCount = CALCULATE(COUNTX('Table','Table'[Status]),FILTER('Table','Table'[Status]="Late")) VAR OCount = CALCULATE(COUNTX('Table','Table'[Status]),ALL('Table')) RETURN DIVIDE(LCount,OCount,BLANK())If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
Absolutely! I am looking to represent a count of late tasks out of all tasks. The maximus value would be the task count as a whole where the value being represented on the visual would be the late tasks out of the full task number. i.e. I have 712 overall tasks and 82 late tasks
