Forum Discussion
Solved
Dynamic parameters in a variable formula
Hi. I want to make two parameters of my formula dynamic, i.e. replace the fixed values with values that the person running the report is selecting. The specific values are WKCurrencyType (=2) and WK...
Hi， konradjonsson
If [WKInvoiceDate],[WKCurrency],[parameter1 value],[parameter2 value] are measure columns, try to encapsulate all conditions with filter function.
Measure:ExchangeRate = VAR _date = 'Sales'[WKInvoiceDate] VAR _currency = 'Sales'[WKCurrency] RETURN CALCULATE ( MAX ( 'Exchange Rates'[ExchangeRates] ), FILTER ( 'Exchange Rates', YEAR ( 'Exchange Rates'[WKDate] ) = YEAR ( _date ) && 'Exchange Rates'[WKSourceCurrency] = _currency && 'Exchange Rates'[WKCurrencyType] = [parameter1 value] && 'Exchange Rates'[WKReportCurrency] = [parameter2 value] ) )Best Regards,
Community Support Team _ Eason
konradjonsson, You can use what if the parameter of some other slicer value
CURRENT FORMULA
ExchangeRate =
VAR _date = 'Sales'[WKInvoiceDate]
VAR _currency = 'Sales'[WKCurrency]
RETURN
CALCULATE( MAX('Exchange Rates'[ExchangeRates] ), year('Exchange Rates'[WKDate]) = year(_date), 'Exchange Rates'[WKSourceCurrency] = _currency, 'Exchange Rates'[WKCurrencyType]=selectedvalues(whatif1[Value]) ,'Exchange Rates'[WKReportCurrency]=selectedvalues(whatif2[Value]) )