Forum Discussion
Chandrashekar
Resolver III
Resolver IIIOpen 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.
Regards,
Chandrashekar B
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]))
6 Replies
- amitchandak
Super User
ChandrashekarHello,
I saw your post but have different requirement where I do not have closed date field.
Regards,
Chandrashekar B
- amitchandak
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
smpa01Community Champion
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