count record with no category

[Revilo]

Hi ,

I want to count records/rows without category. if any from the below categories is in the column, results = TRUE, otherwise, FALSE.

what would be the measure i can use for this.

Ex. Categories:

architecture

engagement

investigation

capacity

SWAT

Thanks

[FreemanZ]

hi @Revilo 

try like:

Measure = 
COUNTROWS(
    FILTER(
        TableName,
        TableName[Categories] IN {"architecture", "engagement", "investigation", "capacity", "SWAT"}
    )
)

[amitchandak]

@Revilo , not very clear. But you can have measures like

countrows(filter(Table, isblank(Table[Category]) ))