Power bi Values are not matching after Excel sheet imported into Power bi Desktop

[Anonymous]

Hi Everyone.i am using Excel datasource for my power bi report . after the import to Ecxcel sheet into power bi Deskstop  value are lightly different  in  Power  bi 

i have column For seperate the  value  

Column Name ->New Scrap    Filtered i choose  Scrapped Value(OK)  values in Excel 

I took the value column  " Amount In '000 USD "

Excel screen shot :

Power Bi Screen shot : 

Filtered i choose  Scrapped Value(NOK)  values in Excel 

Excel screen shot :

Power Bi Screen shot : 

My DAX Query   for both conditions :

G_NOK = CALCULATE(ABS(SUMX('3 Scrapped Value','3 Scrapped Value'[Amount in USD]))/1000,

'3 Scrapped Value'[New Scrap]="Scrapped Value(NOK)")

G_Amount = CALCULATE(ABS(SUMX('3 Scrapped Value','3 Scrapped Value'[Amount in USD]))/1000,

'3 Scrapped Value'[New Scrap]="Scrapped Value(OK)")

i have attached  sample PBI  File and used Excel sheet . 

Test file  

please any one guide me what is the issues ?  thanks in advance  

[Anonymous]

@amitchandak  sir i am tired with New formula . getting different value only 

[amitchandak]

@Anonymous , try like

G_NOK = CALCULATE(ABS(SUMX('3 Scrapped Value','3 Scrapped Value'[Amount in USD])),
filter('3 Scrapped Value','3 Scrapped Value'[New Scrap]="Scrapped Value(NOK)"))/1000.0


G_Amount = CALCULATE(ABS(SUMX('3 Scrapped Value','3 Scrapped Value'[Amount in USD])),
filter('3 Scrapped Value', '3 Scrapped Value'[New Scrap]="Scrapped Value(OK)"))/1000.0