Get values which are within x of each other

[qnt013]

Hi all,

I have two columns, Name and Value. Each name is unique and has a numerical value attacthed to it (from the Value column).

Now I would like to create a measure that returns those names and their values which are within 100 of each other. So essentially, the measure would have to check all values and place a mid point of 100 in this case and -100 and +100 as lower & upper bound range. 

Would this also be possible to make it so that the user can select the 'range'? So I'd have a front end visual with a text box or something and the user would type in 100 and then the visual would alter the results based on user input.

Eg

A - 100

B - 250

C - 200

D- 600

E- 350

Result

A - 100

B - 250

C - 200

E- 350

[amitchandak · Accepted solution]

@qnt013 , You can use what if paratmeter

a measure like

calculate(Sum(table[value]), filter(Table, table[value] >= [Whatifmeasure] ))

refer

https://docs.microsoft.com/en-us/power-bi/desktop-what-if