Subtracting Unique Values issue

[kivanct]

Hi,

Could you please help me about this problem ? Sorry for the language of table which is not English.

I created formula --> SUM(ZD83(Ü.P) - SUM(ZD83(Dış Müşteri Stok)

for Malzeme = 10131476 is taking total of Ü.P that is OK -->1217 + 1217 + 29 --> no isssue
the problem = 10131476 is taking total of Dış Müşteri Stok that is NOT OK --> 1271 + 1271 + 1271.  
I wanna get only one 1271.

How can i create formula ?

Regards... 

[v-jianboli-msft · Accepted solution]

Hi @kivanct ,

Do you want the result to be 1217+1217+29-1271?

If this is the case, try the following formula.

Here is my sample:

Please try:

Measure = SUM('Table'[Value1]) - SUMX(SUMMARIZE('Table','Table'[Value2]),[Value2])

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kivanct]

Thanks a lot for your help !