topic Re: Min of ABS Measure in DAX Commands and Tips

Min of ABS Measure

BeaBF — Thu, 05 May 2022 10:48:31 GMT

Hello everyone! This time I need you.

I need to calculate the minimum value among the absolute values of a column grouped by key, in order to put in that line the sum of the same column.

I try to explain, the data:

CHIAVE	DELTA_ADJ
AAA	-444,471873
AAA	380,175
BBB	-28323017,83
BBB	-80752,60925

I need to compute the sum of the column DELTA_ADJ grouped by CHIAVE, so:

-64,296873

-28403770,44

and put it in correspondence with the minimum value of the absolute value of each key, in this way:

CHIAVE	DELTA_ADJ	MIN VALUE
AAA	-444,471873	0
AAA	380,175	-64,296873
BBB	-28323017,83	0
BBB	-80752,60925	-28403770,44

EVERYTHING MUST BE DONE BY MEASURE, WITHOUT CALCULATED COLUMNS

THX,

Re: Min of ABS Measure

tamerj1 — Thu, 05 May 2022 12:11:46 GMT

Hi BeaBF
You can try https://we.tl/t-rWuYaQz0GU

MIN VALUE = VAR AbsCurrentValue = ABS ( MAX ( Data[DELTA_ADJ] ) ) VAR ChiaveTable = CALCULATETABLE ( Data, ALLEXCEPT ( Data, Data[CHIAVE] ) ) VAR GroupedBySum = SUMX ( ChiaveTable, Data[DELTA_ADJ] ) VAR AbsMinValue = MINX ( ChiaveTable, ABS ( Data[DELTA_ADJ] ) ) VAR Result = IF ( AbsCurrentValue = AbsMinValue, GroupedBySum, 0 ) RETURN Result

Re: Min of ABS Measure

BeaBF — Thu, 05 May 2022 12:22:57 GMT

tamerj1

Crazy! that's just what I wanted!

A thousand thanks!