Skip to main content
cancel
Showing results for 
Search instead 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

Reply
majdkaid22
Helper V
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

 

CCYExposure $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])))

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
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.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
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.

@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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors