Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
[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!
Solved! Go to Solution.
Hi,
Try this measure
=SUMX(FILTER(SUMMARIZE(VALUES(Data[Clientele]),[Clientele],"ABCD",SUM(Data[Importe])),[ABCD]>0),[ABCD])
Hope this helps.
Hi,
Try this measure
=SUMX(FILTER(SUMMARIZE(VALUES(Data[Clientele]),[Clientele],"ABCD",SUM(Data[Importe])),[ABCD]>0),[ABCD])
Hope this helps.
It works! thanks!
It helped me a lot.
Greetings from Argentina!
You are welcome.
I forgot sth, I need this to put in a Card
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |