New Measure Powerpivot Unique Count

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

Can you just simply add the document number to the values field and select distinct count? Or do you need to reference this calculation for other formulas?

Thank you very much! I did not think of absolute values. DISTINCTCOUNT did not work for me but the following formula using ABS did


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