Forum Discussion

AllisonGis's avatar
AllisonGis
Regular Visitor
2 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

Kishore_KVN's avatar
Kishore_KVN
Solution Sage
2 years ago

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!!

  • AllisonGis's avatar
    AllisonGis
    Regular Visitor
    2 years ago

    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