Overdue Tickets

[Sowjanya_09]

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 Create any ideas?

[Sowjanya_09]

It worked very well, Thank you so much. 

[PhilipTreacy · Accepted solution]

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