Dealing with Measure Totals

Hi Ashish,

Thank you for replying! 

As you can see, the total is 34 which is correct. If you add up the subtotals (10+17+12+9 = 48), you get a different result. The addition of the subtotals is incorrect.  The subtotals will count the value even if the same Document No. has the value (42-CHECK-SERIALNO) on a different date.

Therefor, I would like to create a measure: If the "Document No." occurs several times on different dates by value (42-...), then I do not want to count this (double) in the subtotals. It should only count the first time the "Document No." hits the status (42-...).

Unfortunately, I cannot figure out how to do this.

Do you have experience how to do this?

Thanks in advance.

Patrick