Forum Discussion

Sowjanya_09's avatar
Sowjanya_09
Frequent Visitor
4 years ago
Solved

Overdue Tickets

I want count of OVERDUE tickets I have a Column Name  Status description and OWNER I have to count Overdue Tickets By Owner (OVERDUE  = not equal to closed and not equal to Duplicate) How to Crea...
  • PhilipTreacy's avatar
    4 years ago

    Hi Sowjanya_09 

     

    Download sample PBIX file

     

    Add Owner and StatusDescription (renamed to Overdue) to a table.  Aggregate StatusDescription by Count.

     

    Add StatusDescription as a filter to the visual.  Select all StatusDescriptions except Closed and Duplicate.

     

    Regards

     

    Phil