Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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( SUM('Open Trades'[Base USD]) + CALCULATE( SUM('Open Trades'[Quote USD]), USERELATIONSHIP(CCY[CCY],'Open Trades'[Quote CCY])))
Solved! Go to Solution.
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
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
@Anonymous Your formula did the trick. Now, I need to understand how/why it worked!
Thanks for sharing the earlier post. quite helpful!
Cheers,
Majd
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
60 | |
51 | |
36 | |
36 |
User | Count |
---|---|
81 | |
72 | |
58 | |
45 | |
44 |