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

Helper V

## Total of Absolute measure is not returning Absolute sum of values

Hi guys,

Am stuck getting AbS function to give me the result am looking for.

I need the total for Exposure \$ AbS to give me the Absolute sum of all the values in the column=

 \$1,011,908,128

 CCY Exposure \$ Exposure \$ AbS USD \$408,960,847 \$408,960,847 AUD \$79,943,739 \$79,943,739 CAD \$71,285,559 \$71,285,559 CHF (\$33,703,177) \$94,672,286 XAU (\$37,513,819) \$37,513,819 JPY (\$64,185,207) \$64,185,207 NZD (\$74,873,822) \$11,258,328 GBP (\$137,427,513) \$29,208,447 EUR (\$214,879,896) \$214,879,896 Total (\$2,393,289) \$2,393,289

I know this may be a little trick I have to add, but am not getting there...

Appreciate if anyone could help

`Exposure \$ AbS = ABS([Exposure \$])`

```Exposure \$ = CALCULATE(
+
CALCULATE(

1 ACCEPTED SOLUTION
Community Support

Hi @majdkaid22,

it is a common total level issue of measure, I'd like to suggest you take a look at following link:

Measure Totals, The Final Word

You can also try to use following measure if it works for your requirement:

```Measure =
VAR list =    VALUES ( CCY[CCY] )VAR summary =    SUMMARIZE (        ALLSELECTED ( CCY ),        CCY[CCY],        "Exposure \$ abs", ABS ( [Exposure \$] )    )RETURN    SUMX ( FILTER ( summary, [CCY] IN list ), [Exposure \$ abs] )
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
2 REPLIES 2
Community Support

Hi @majdkaid22,

it is a common total level issue of measure, I'd like to suggest you take a look at following link:

Measure Totals, The Final Word

You can also try to use following measure if it works for your requirement:

```Measure =
VAR list =    VALUES ( CCY[CCY] )VAR summary =    SUMMARIZE (        ALLSELECTED ( CCY ),        CCY[CCY],        "Exposure \$ abs", ABS ( [Exposure \$] )    )RETURN    SUMX ( FILTER ( summary, [CCY] IN list ), [Exposure \$ abs] )
```

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Helper V

@v-shex-msft Your formula did the trick. Now, I need to understand how/why it worked!

Thanks for sharing the earlier post. quite helpful!

Cheers,

Majd

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.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors