vladnech Tracker

Re: Calculate amount on Currency slicer selection

vladnech — Mon, 15 May 2017 23:12:37 GMT

Ah. Thanks a lot. For some reason, I thought metrics can not be used in Visuals.

vladnech — Mon, 15 May 2017 13:56:13 GMT

Sorry, mate, probably you did not see my comment:

Nominal is not the column from Dataset - it is the calculated column in the model, which = m_Nominal.

At the same time, m_Nominal is the conversion, using the rate (I don't understand why this trick should work - just used some example).

Could you share your sample file with working exchange rate?

Thanks,

Vlad

vladnech — Mon, 15 May 2017 11:48:19 GMT

NominalInAUD is the column.

Here are the data models:

vladnech — Mon, 15 May 2017 11:34:16 GMT

Hi mate

Sorry, for confusion. Yes, Nominal is placed into the table.

Nominal = m_Nominal.

Thanks,

Vlad

vladnech — Mon, 15 May 2017 06:41:49 GMT

Hi guys

Looks like I have found several threads, how to convert amount on selected Currency, but, for some reason, none of them works for me.

I have currecies with rates table (SelectedCurrencies) - it is used in a Slicer:

I have the Holdings tables, where I have specified two measures:

m_Rate = IF(ISFILTERED(SelectedCurrencies[Currency]), MAX(SelectedCurrencies[DefaultRate]), 1)

m_Nominal = CALCULATE(SUM([NominalInAUD])/[m_Rate])

Holdings and SelectedCurrencies do not have any relations:

NOTE: Relations on this screenshot are for different tables

But does not make any conversion, clicking on any currency it does not re-calculate the amount (Nominal):

Nominal stays the same on Currency selection. Looks like ISFILTERED does not work - always false.

Thanks in advance for your help,

Vlad