Calculated column based on slicer

[Anonymous]

Hi,

I have one table of NZD revenues and another table of NZD/USD exchange rates.

I want to create a calculated column for USD revenues from a filtered NZD/USD exchange rate.

I.e. I set my slicer to 0.50 for the exchange rate, and my NZD revenue of 1.00 becomes USD revenue of 0.5 in the calcualted column.


Thanks,
Tom. 

[tarunsingla]

Calculated columns do not support dynamic values (like from What If parameters). You would need a calculated measure instead.