Open and Closed : Count

[Chandrashekar]

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,

Chandrashekar B

[smpa01]

@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]

Hello,

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

Regards,

Chandrashekar B

[amitchandak · Accepted solution]

@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]

Hello,

Thanks it is working fine.

Regards,

Chandrashekar B

[amitchandak]

@Chandrashekar , I have blog on similar topic, see if that can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Yet to check the file

[Chandrashekar]

Hello,

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

Regards,

Chandrashekar B