Hi,

I am trying to create a new measurement which would count the amount of unique document numbers, the problem is that I need to count values that are lower than -10 and values greater than +10

'ALL CC'[DOC# CC] are the document numbers and 'ALL CC'[USD] is the related value that should be lower than -10 or greater 10.

So far I came up with the following formula, but it is counting document numbers that have both plus and minus transactions twice.

=CALCULATE(COUNTROWS(DISTINCT('ALL CC'[DOC# CC])),'ALL CC'[USD]>10)+CALCULATE(COUNTROWS(DISTINCT('ALL CC'[DOC# CC])),'ALL CC'[USD]<-10)

is there a quick fix to this formula?

Thanks in advance