I have a table “Measurement” to perform calculations for Curtain Rod in which I have a field for the users to add the measurement in Inches and in same table I am also calculating the Product cost in which I want the price to be picked up from spread sheet only for product whose size is matching the measurement input done by user. So I have created a field Size of Rod which is also connected to my spread sheet table using valid if condition. And if have written a formula something like below :
Select (Filter(Curtain Rod[Size of Curtain Rod],[Length of curtain rod (Inches)]/12))
Where in Curtain Rod is the name of table,Size of Curtain is field in curtain rod table which holds the sizes of curtain rod and then I have added a formula that pick up value from Spreadsheet which matched the calculation of length of the rod (this is user input field for measurement) in inches.
So in short if the user input is 36 inches then from spread sheet it should pick up value only of size of rod of 3 (36/12) and show only those product prices.
It would be great help if some guidance can be provided on how to achieve this? As I am getting an error that filter condition can only have a table