topic Re: count record with no category in DAX Commands and Tips

count record with no category

Revilo — Mon, 20 Feb 2023 07:40:51 GMT

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

amitchandak — Mon, 20 Feb 2023 08:40:02 GMT

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

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

FreemanZ — Mon, 20 Feb 2023 08:41:25 GMT

try like:

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