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
1 ACCEPTED SOLUTION
Result measure : =
COUNTROWS (
SUMMARIZE (
FILTER ( 'Table', NOT ( CONTAINSSTRING ( 'Table'[Staff Name], "resign" ) ) ),
'Table'[Staff Name]
)
)
Result measure : =
COUNTROWS (
SUMMARIZE (
FILTER ( 'Table', NOT ( CONTAINSSTRING ( 'Table'[Staff Name], "resign" ) ) ),
'Table'[Staff Name]
)
)
Helpful resources
Fabric Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI Monthly Update - May 2026
Check out the May 2026 Power BI update to learn about new features.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
