Hi,
I'm trying to add a static value to a data item by creating a new calculated measure. The problem I'm having is that there is a filter and I want a different number to be added for different filter values. Currently, I'm doing this :
IF ( 'report_brand'n = 'ABC' )
RETURN ( 'Number YTD LY (#)'n + 123456 )
ELSE (
IF ( 'report_brand'n = 'XYZ' )
RETURN ( 'Number YTD LY (#)'n + 654321 )
ELSE 'Number YTD LY (#)'n )
123456 and 654321 are the numbers I wanna add to 'Number YTD LY (#)' on the basis of report_brand chosen in filter. Currenlty it looks as if it is adding the number to the total value of 'Number YTD LY (#)' and not to the 'Number YTD LY (#)' for the chosen report_brand.