Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
the following expression works fine for me and supposed to make calculation for specific name as added on the set analysis.
Now when I go on my list box "Name" and make different selection, it changes the numbers and give wrong values. how can I make sure the values dont change when I select a value on the Name column?
RangeSum(Above(
((Sum({$<Flag = {'1'}, [Name]= {'ABC'}>}[Price]) - above(Sum({$<Flag = {'1'}, [Name]= {'ABC'}>}[Price])))
/ ([Date] - above([Date]))
-
0.06)
*
([Date] - above([Date])) , 0,RowNo())))
so I created another measure and add the second expression with if. I see the numbers just fine.. when I combine them into one all works then when I select a different name I get wrong values....