Hello!
I have Dimensional Model in Report Studio, there are 1 dimension and 2 Measures ([Measure 1], [Measure 2]).
There are such elements in Dimension: [Element 1], [Element 2], [Element 3], [Element 4].
And I need to create calculated measure which will use [Measure 1] for [Element 3] and [Measure 2] for all other elements.
I tried that way: if [Dimension] = [Element 3] then ([Measure 1]) else ([Measure 2])
but it doesnt work.
Thanks!
So, found an answer :)
http://www.youtube.com/watch?v=98WBkwK1J1w&feature=youtu.be