Forum Discussion
Calculate amount on Currency slicer selection
If Nominal is a calculated column and = to m_Nominal use the m_Nominal on your visual and it works, in my sample file I have used the measure in my visual not a calculated column.
Mfelix
NominalInAUD is the column.
Here are the data models:
Super UserHi vladnech,
Sorry for insisting on this if you have a column name Nominal in you Visual that is corresponding to your column Nominal in you dataset in your visual you should use the m_nominal to see the value with the calculated exchange rate, to my knowledge you cannot change the names of the measures/columns in the visuals so if you are looking at the Table Visual and see the Nominal that is the column you are refering to and not m_Nominal.
Mfelix
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