multiple column filter in one slicer/drop down

[KatMaciejewska]

Hi Everyone!
I am currently working on one project and I would like to create a table, which could be prefiltered by a user by a column with values selected by this user, like in the attached example:

So let's say, I have a columns in the table which are Publisher, Ad Group Name, Impressions, Clicks, CTR, etc and I would like to have a drop down list at the top of this table where I could pick a column by which I would like to prefilter the table results, for e.g. I would like to filter a table by column called "Conversions", where the value is higher than 1200, or filter the table out by column "Impressions", where the value is less than 2000.
Would thi be possible at all? To have a one filter with many columns as a selection of a filter?

Hope my explanation makes sense! Thank you in advance. 

[RicoZhou2 · Accepted solution]

Hi @KatMaciejewska ,

I suggest you to create a measure to filter your visual.

Measure = 
VAR _Conersions = 
CALCULATE(SUM('Table'[Conversions]))
VAR _Impression = 
CALCULATE(SUM('Table'[Impressions]))
RETURN
IF(OR(_Conersions>1200,_Impression<2000),1,0)

Add this measure into visual level filter in your table visual and set it to show items when value equal to 1.

My Sample:

Result is as below.

Best Regards.