How to get the right total in a matrix of the minimum between two measures

[Alice_T]

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

[Anonymous]

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

[DataInsights · Accepted solution]

@Alice_T,

Try this measure:

c = 
SUMX (
    SUMMARIZE ( flow, flow[Letter], flow[Short], flow[Year] ),
    MIN ( ABS ( [a] ), ABS ( [b] ) )
)