Matrix Exclude Filter

[cmfranks]

I have projects in one column which have another column for status (tracked and shipped),  I only want to summarize qty and return projects that do not contain tracked,  thus it is fully shipped.  If I filter out shipped it will still summarize projects that contain tracked but only summarize the qty shipped.  I don't know how to exclude a column for projects that contain another column status that contain tracked

[amitchandak]

@cmfranks , Try like

Countx(filter(Summarize( Table, Table[Project], "_1", countx(filter(Table, Table[Status] ="tracked"), Table[project])), isblank([_1]) ), [project])