Forum Discussion

SUNNY_ISLAND's avatar
SUNNY_ISLAND
Frequent Visitor
4 years ago
Solved

Column total incorrect for converted amounts

I have the following dax formula to convert values from various currencies to SGD. The total column does not add up. Instead of showing $16.5m, it is showing $25.2m. The converted amount on each row...
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

SUNNY_ISLAND 
Please try the following version:

Total value in SGD =
VAR _CURRENCY =
    MAX ( Data[Report curr] )
RETURN
    SUMX (
        data,
        CALCULATE (
            MAX ( 'Exch rate'[Exch rate] ),
            'Exch rate'[Report Curr] = _CURRENCY
        ) * ( Data[Value] )
    )
SUNNY_ISLAND's avatar
SUNNY_ISLAND
Frequent Visitor
4 years ago

Thanks for your suggestion but it is still not working. The end results remain the same. Would appreciate alternative suggestions. Much thanks