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]))
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Chandrashekar  you need a schema like this

 

and three measures as follows

_Closed = CALCULATE(COUNT('Table'[Ticket]),FILTER(VALUES('Table'[Status]),'Table'[Status]="Closed"))

_Open = CALCULATE(COUNT('Table'[Ticket]),FILTER(VALUES('Table'[Status]),'Table'[Status]="Open"))

_closedPCT = DIVIDE([_Closed],COUNTROWS('Table'))

 

 

 

 

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

    Hello,

     

    Thanks it is working fine. May I know purpose of using underscore with variable.

    Regards,

    Chandrashekar B