cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Memorable Member

## Min of ABS Measure

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,

BF

1 ACCEPTED SOLUTION
Super User

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``````

2 REPLIES 2
Super User

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``````

Memorable Member

Crazy! that's just what I wanted!

A thousand thanks!

BF

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors