Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi, I need help solving this problem:
There is a matrix containing two measures representing the sum of a column:
a = CALCULATE(SUMX(flow, value), flow[name]="A")
b = CALCULATE(SUMX(flow, value), flow[name]="B")
Subsequently, a second measure is created which represents the minimum absolute value between these two measures:
c = MIN(ABS([a]), ABS([b]))
While this measure correctly displays the numbers per row, it fails to provide the accurate total. Instead of summing the values above the total, it computes the minimum value from the sum of the other two measures.
Here is the matrix:
Letter | Short | Year | a | b | c |
P | A | 2024 | 403 | -367 | 366.92 |
P | A | 2025 | 90 | -90 | 90.36 |
P | A | 2026 | |||
P | B | 2024 | -110 | ||
P | B | 2025 | -18 | ||
P | B | 2026 | |||
P | C | 2024 | 128 | -14 | 13.94 |
P | C | 2025 | |||
P | C | 2026 | |||
P | D | 2024 | 3 | -276 | 2.78 |
P | D | 2025 | -61 | ||
P | D | 2026 | -18 | ||
P | E | 2024 | 8 | ||
P | E | 2025 | |||
P | E | 2026 | |||
P | F | 2024 | 127 | ||
P | F | 2025 | |||
P | F | 2026 | |||
P | G | 2024 | 1 | -3 | 0.64 |
P | G | 2025 | |||
P | G | 2026 | |||
P | H | 2024 | -57 | ||
P | H | 2025 | -21 | ||
P | H | 2026 | -15 | ||
P | I | 2024 | -3 | ||
P | I | 2025 | |||
P | I | 2026 | |||
P | J | 2024 | 5 | ||
P | J | 2025 | |||
P | J | 2026 | |||
P | K | 2024 | 0 | ||
P | K | 2025 | |||
P | K | 2026 | |||
P | L | 2024 | 7 | -1 | 0.51 |
P | L | 2025 | |||
P | L | 2026 | |||
P | M | 2024 | 40 | ||
Total from matrix | 812 | -1054 | 812 | ||
Total that i want | 812 | -1054 | 475.15 | ||
Solved! Go to Solution.
Try this measure:
c =
SUMX (
SUMMARIZE ( flow, flow[Letter], flow[Short], flow[Year] ),
MIN ( ABS ( [a] ), ABS ( [b] ) )
)
Proud to be a Super User!
Hi @Alice_T ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Try this measure:
c =
SUMX (
SUMMARIZE ( flow, flow[Letter], flow[Short], flow[Year] ),
MIN ( ABS ( [a] ), ABS ( [b] ) )
)
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
73 | |
66 | |
60 |