Constant Background colour

[zyn]

Hi,

I had a requirement where i needed to make my chart static which i did by adding <DIM1,DIM2>,

but when selecting any dimension values it gives background for that particular dimension, i dont want my background color to change please suggest some way, below is my background expression:

=If((

(Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) ) <= sum({<DITDATE>}Threshold_Green)) 

and (WildMatch(Measure,'BAKL','JAML','FATM'')), LightGreen(),

    If(Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) >= sum({<DITDATE>}Threshold_Red)

    and (WildMatch(Measure,'BAKL','JAML','FATM'')),'#ec6969', //LightRed(),

    If((Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) > sum({<DITDATE>}Threshold_Green)) and (Sum({<DITDATE = {'$(=date(max(DITDATE)))'},Table_Flag = {'JAT'}>}TMP_Count) < sum({<DITDATE>}Threshold_Red) )

    and (WildMatch(Measure,'BAKL','JAML','FATM'')), '#ffbf00','#d4e0ec'

)))

[Sayed_Mannan]

Your current expression uses set analysis which is selection sensitive. you need to use set analysis that ignores selections by adding 1 to the set modifier.

for e.g- instead of Sum({<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count 

you can use
 Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count

based on this, here is your revised background color expression:

=If(
    (Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) <=
     Sum({1<DITDATE>} Threshold_Green)) and
    WildMatch(Measure, 'BAKL', 'JAML', 'FATM'),
    LightGreen(),
    If(
        Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) >=
        Sum({1<DITDATE>} Threshold_Red) and
        WildMatch(Measure, 'BAKL', 'JAML', 'FATM'),
        '#ec6969',
        If(
            Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) >
            Sum({1<DITDATE>} Threshold_Green) and
            Sum({1<DITDATE = {'$(=date(max(DITDATE)))'}, Table_Flag = {'JAT'}>} TMP_Count) <
            Sum({1<DITDATE>} Threshold_Red) and
            WildMatch(Measure, 'BAKL', 'JAML', 'FATM'),
            '#ffbf00',
            '#d4e0ec'
        )
    )
)

I hope this helps.

[zyn]

@Sayed_Mannan i  tried using above expression but it is not working.