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.
Hi all,
I have somehow a tricky problem.
I want to create a measure which sums the negative values per Company and Account:
Company | Account | Value |
A | K100 | 10 |
A | K100 | -10 |
A | K200 | 20 |
B | K100 | 20 |
B | K100 | -30 |
B | K200 | -40 |
C | K100 | 10 |
C | K200 | 20 |
C | K200 | -30 |
So for the table above I would like to get the result of -60:
> -10 for Company B and Account K100
> -40 for Company B and Account K200
> -10 for Company C and Account K200
I am only able to sum all negative values with the result of -110....
Any chance that I can group within the measure by Company and Account?
Any help would be much appreciated.
Many thanks
Philip
Solved! Go to Solution.
Hi, please try with this measure:
SumNegatives = SUMX ( SUMMARIZE ( Table1, Table1[Company], Table1[Account], "SumValues", CALCULATE ( SUM ( Table1[Value] ) ) ), IF ( [SumValues] < 0, [SumValues], 0 ) )
Regards
Victor
Lima - Peru
Hi, please try with this measure:
SumNegatives = SUMX ( SUMMARIZE ( Table1, Table1[Company], Table1[Account], "SumValues", CALCULATE ( SUM ( Table1[Value] ) ) ), IF ( [SumValues] < 0, [SumValues], 0 ) )
Regards
Victor
Lima - Peru
Victor,
many thanks! You saved my day, thats it!
Best
Philip
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |