Column total incorrect for converted amounts

Hi,

I think this topic is in regards to a similar problem: https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/td-p/547907

Hi SUNNY_ISLAND ,

Please have a try.

Based on the measure[Total value in SGD].

_contract_ = 
var _b = SUMMARIZE('Date','Date'[Report curr],"aaa",'Data'[Total value in SGD])
return
IF(HASONEVALUE('Date'[Report curr]),'Data'[Total value in SGD],SUMX(_b,[aaa]))

Or you can use Other unique columns replace the column 'date'[Report curr].

If I have misunderstood your meaning, please provide a pbix file without privacy information and more details with your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.