Select Value using if not blank but only show values that are in the same row.

[Jpaulsen]

Hello,

Little lost here. Wondering if someone could help me out. 

I have this formula which works great but I have manually select the values I want as it show the whole column. Is there away where this formal can modified to auto select the values that matches. 

Here is the formal I working on. SELECT(equipment[Unit],NOT(ISBLANK([Type of filter])))

[dbaum]

I don't clearly understand what you're trying to accomplish. Maybe the SWITCH function would help you. For example:

SELECT(equipment[Unit],NOT(ISBLANK(
SWITCH([Type of filter], 
"Engine Oil Filter", [Engine Oil Filter], 
"Fuel Filter", [Fuel Filter], 
...
)
)))

[Jpaulsen]

Hello, 

On a earlier post "Can you use a dropdown list in a select formula",WillowMobileSys helped me that when I used my dropdown on "type of filter" that "parts number" value would show the filters that associated with the type of filter. Now what I like to have is once those two are enter that my "unit" value will automatically show the units (equipment) that uses that filter. 

I just can't grasp the formula to do that using the select with multiple condition only if the part number value is not blank. 

Thank you in advance