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]))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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,

     

    Thanks it is working fine.

     

    Regards,

    Chandrashekar B