Filtering and measures

[Anonymous]

I have 3 machines that produce output that is affected by part size and pressure. I conducted a series of experiments to build mathematical models for each machine that can estimate the output based on part size and pressure. Using these models, I have built a simple Power BI dashboard where the user can select the machine type, the pressure and the desired output in order to find out what part size to use. I've included an image of the dashboard below. I have 3 filters on the page--machine type (a list), pressure (a list) and result (a slider). A card holds the measure used to estimate the needed part size. I also have a simple table showing the available part sizes and their corresponding part numbers. Here are my questions:

1) The range of output (displayed on the dashboard) differs for each machine type. How can I make the user's selection of machine type change the range of output on the Result slider?

2) How can I get the estimate of part size (which I currently have as a measure) to filter the part size table? What I'd actually like is for the output of that measure (or whatever is a better solution) to filter the part size table so it displays the nearest size to the estimate, as well as the next size below and the next size above. If the smallest part size is indicated, I'd want it to display the two smallest. If the largest part size is indicated, I'd want the two largest part sizes displayed. In all other instances, I'd want a total of 3 part sizes displayed. If I can only have the closest part size displayed, I can live with that, as I realize my ask may be very complicated.

I've done a lot of searching in Power BI forums trying to find solutions to this, but have not had a lot of luck. I'm quite a novice in Power BI, so perhaps I haven't used the right search terms or understood related solutions. Any help would be greatly appreciated. Thank you!

Here is the DAX for my measure:

Est Part Size = (average(RawData[Result])-AVERAGE(RawData[Constant])-AVERAGE(RawData[Pressure Coeff])*AVERAGE(RawData[Pressure]))/(AVERAGE(RawData[Part Size Coeff])+AVERAGE(RawData[Interaction Coeff])*AVERAGE(RawData[Pressure]))

[stevedep]

You can use a measure as a visual filter. 

Kind regards, Steve. 

[Anonymous]

@stevedep,

Not sure if I follow. I tried dragging the measure to "Filters on this visual" for the Part Size table, but then don't know how to get it to trigger from the measure value displayed. I'm given the choice of "Show items when the value:" and if I select "is less than or equal to", I don't know what to put in the next box.

Thank you!