Dax to get the Values with in the selected range

[AnilKumar]

Hi all,

I Have  raw data like Item and  its Cost . I need to get the results based on the % and Selected Value like if i Select 10% and Cost as 50/- then, It should show the components with cost  between  45 to 55 . Is there any possibility of  that?

Thanks in advance,

Vishnu Priya

[v-chuncz-msft]

@AnilKumar 

You may add what-if parameters first, then drag measure below to Visual level filters and set Show items when the value is 1.

Measure =
IF (
    ABS ( SUM ( 'Table'[Value] ) / 'Parameter Value'[Parameter Value Value] - 1 ) <= 'Parameter Percent'[Parameter Percent Value],
    1
)