Excluding values using Set Analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Excluding values using Set Analysis

antoniotiman — Fri, 02 Jun 2017 07:03:43 GMT

-={'NA'}