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

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])))

Screen Shot 2022-10-02 at 8.39.21 AM.pngScreen Shot 2022-10-02 at 3.48.38 PM.png

2 REPLIES 2
Top Labels in this Space