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.

     

     

Anonymous's avatar
Anonymous
Not applicable
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.

 

 

  • AllisonGis's avatar
    AllisonGis
    Regular Visitor
    2 years ago

    Hi Anonymous,

    Thank you so much for your help this is exactly what I was looking for!