Forum Discussion
Discount Count
Hi Experts,
Below is my sample data. Marked red ones are staff who resigned. I need to the count distinctvalues of staff Name who haven't resigned.
Please helpe me!
Thank you
- Result measure : =COUNTROWS (SUMMARIZE (FILTER ( 'Table', NOT ( CONTAINSSTRING ( 'Table'[Staff Name], "resign" ) ) ),'Table'[Staff Name]))
2 Replies
- Jihwan_Kim
Super User
Result measure : =COUNTROWS (SUMMARIZE (FILTER ( 'Table', NOT ( CONTAINSSTRING ( 'Table'[Staff Name], "resign" ) ) ),'Table'[Staff Name]))