Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
-={'NA'}
-={'NA'}