Showing incorrect values when slicer is selected

[Anonymous]

Hi, I have defined parameter from 1 to 100 called as threshold value. I created a new column and that column I have used in a slicer. But when I select " At above Threshold"-it shows both the values "At above Threshold values" and "Below Threshold values", but when we select  Below Threshold or No change, it shows the correct values for both. Here, I selected "At Above Threshold"-Green color indicate-Below Threshold, Red color indicate-At above Threshold, Grey color-No Change.

What I am doing wrong here? Any Solution?

Measure for new column-

Filter threshold =

 IF(

        new_nds_release_diff_ds[Metric_value]-new_nds_release_diff_ds[old_Metric_value]=0.00,"No Change",

    IF

      (

        'Difference % Threshold'[% Diff]>=SELECTEDVALUE('Difference % Threshold'[Difference % Threshold]),"At/Above Threshold",

        IF(

    'Difference % Threshold'[% Diff]<SELECTEDVALUE('Difference % Threshold'[Difference % Threshold]),"Below Threshold"

 )))

[Anonymous]

yes, I have got the answer. I have created 3 different measures and then I have created table of these measures of same name and then again, I have created new measure and that I have applied in page filter.

[johnt75 · Accepted solution]

Calculated columns are only calculated during data refresh, so they pay no attention to slicers and filters. To respond dynamically to slicer changes you need to create a measure instead. try

Filter threshold =
IF (
    SELECTEDVALUE ( new_nds_release_diff_ds[Metric_value] )
        - SELECTEDVALUE ( new_nds_release_diff_ds[old_Metric_value] ) = 0.00,
    "No Change",
    IF (
        'Difference % Threshold'[% Diff]
            >= SELECTEDVALUE ( 'Difference % Threshold'[Difference % Threshold] ),
        "At/Above Threshold",
        IF (
            'Difference % Threshold'[% Diff]
                < SELECTEDVALUE ( 'Difference % Threshold'[Difference % Threshold] ),
            "Below Threshold"
        )
    )
)

this is assuming that [% Diff] is a measure.