Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago
Solved

Open and Closed : Count

Hello Team,   Can you please help me in getting below counts. Data should change based on slicers(File Attached). 1. Open and closed count 2. Percentage ticket closed. PBIX FIle    Regards, C...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Chandrashekar , Try following measures

     

    Open count = countx(FILTER('Table', 'Table'[Status] ="Open"), [Ticket])

Closed count = countx(FILTER('Table', 'Table'[Status] ="Closed"), [Ticket])

Close % = divide([Closed count], COUNTX('Table', [Ticket]))
  • Chandrashekar's avatar
    Chandrashekar
    Icon for Resolver III rankResolver III
    4 years ago

    Hello,

     

    I saw your post but have different requirement where I do not have closed date field.

     

    Regards,

    Chandrashekar B