Hi all,
I was hoping that somebody could help me simplify my dax code because I get an error when publishing my report to the workspace (memory is not enough).
I got two tables:
One with my stock value (with local currencies)
One with my currency conversion rates
I want to simply convert my stock value in local currency to SEK currency (first measure) but because of the issue we have regarding measure and totals in tables I use a second measure with SUMX to sum the results of the first measure.
First measure:
Stock Value SEK - no sum =
VAR
_currency = MAX('BIG Item Stockroom Balance'[CurrencyCode])
VAR
_conversionRate =
CALCULATE (
MAX( 'BIG Exchange Rate'[SekRate] )
,'BIG Exchange Rate'[CurrencyCode] = _currency
)
VAR
_StockValueSEK =
_conversionRate * SUM('BIG Item Stockroom Balance'[StockValueLocal])
Return
_StockValueSEK
Second Measure:
Stock Value SEK =
SUMX('BIG Item Stockroom Balance',[Stock Value SEK - no sum])
Thanks in advance!
