Excluding values using Set Analysis

[Anonymous]

Hello All,

I have a data set as follows:

I need to exclude all the Change Order Numbers that have the Owning group value as NA and count the rest.

I have used the below expression but it doesn't seem to work.

count(DISTINCT{$<Owning_Group-='NA'>}[Change Order Number])

Suggestions please.

[antoniotiman · Accepted solution]

-={'NA'}