topic Re: Showing incorrect values when slicer is selected in DAX Commands and Tips

Showing incorrect values when slicer is selected

Anonymous — Wed, 18 Jan 2023 11:49:12 GMT

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",

(

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

IF(

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

)))

Re: Showing incorrect values when slicer is selected

johnt75 — Wed, 18 Jan 2023 17:00:37 GMT

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.

Re: Showing incorrect values when slicer is selected

Anonymous — Tue, 24 Jan 2023 08:41:15 GMT

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.