Suma de sumas bajo una condición / Sum of sums under one condition

[marcoslopez]

[ES]
Hola a todos, estoy intentando hacer algo que paso a explicar a continuación, pero no tengo mucha experiencia en DAX.

Mis datos:
Cliente | Importe
A   |    5
B   |    -10
A   |    -3
C   |    -5
C   |    -10
B   |    -7
B   |    25
A   |    1
C   |    5

Paso intermedio
Cliente | Importe
A   |    3
B   |    8

Valor final que debo mostrar:
11


En síntesis, debo mostrar la suma de importes de los clientes cuya suma > 0

[EN]
Hello everyone, I'm trying to do something that I'll explain next, but I do not have much experience in DAX.

My data:
Cliente | Importe
A   |    5
B   |    -10
A   |    -3
C   |    -5
C   |    -10
B   |    -7
B   |    25
A   |    1
C   |    5

Intermediate step
Cliente | Importe
A   |    3
B   |    8

Final value that I must show
11

In summary, I must show the sum of customer amounts whose sum> 0

Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

=SUMX(FILTER(SUMMARIZE(VALUES(Data[Clientele]),[Clientele],"ABCD",SUM(Data[Importe])),[ABCD]>0),[ABCD])

Hope this helps.

[marcoslopez]

It works! thanks!
It helped me a lot.

Greetings from Argentina!

[Ashish_Mathur]

You are welcome.

[marcoslopez]

I forgot sth, I need this to put in a Card