Forum Discussion
multiple column filter in one slicer/drop down
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 exampl...
Hi Anonymous ,
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.
RicoZhou2
Resolver I
Resolver IHi Anonymous ,
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.