Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

     

    Result measure : =
    COUNTROWS (
    SUMMARIZE (
    FILTER ( 'Table', NOT ( CONTAINSSTRING ( 'Table'[Staff Name], "resign" ) ) ),
    'Table'[Staff Name]
    )
    )
     
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

 

Result measure : =
COUNTROWS (
SUMMARIZE (
FILTER ( 'Table', NOT ( CONTAINSSTRING ( 'Table'[Staff Name], "resign" ) ) ),
'Table'[Staff Name]
)
)
 
 
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Awesome. Thank you very much Jihwan