Parsing filter methods

[Anonymous]

Hello

1) I generated Table1 with a series:

1

2

etc

2) I put the above series to a slicer visual so that the user can choose any combination of values eg. 1, 3, 5, etc.

3) I want to use the min and max of the above selected values as a filter to another Table2 so that I include the rows from Table2 where Table2.Col1<max(Table1.Col1) ie. the max of all the selected values of the series

KEEPFILTERS does not seem to work, SELECTEDVALUE only returns the first selected value.

Any idea?

It would be good if you also list alternative ways (I know one is using variables, any other?)

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I suggest you to try to create a measure to filter your visual. I think there should be no relationship between Table1[Col1] and Table2[Col1].

Measure = 
VAR _MAX_COL1_TABLE1 = MAX(Table1[Col1])
RETURN
IF(SUM(Table2[Col1])<_MAX_COL1_TABLE1,1,0)

Add this measure into the visual level filter and set it to show items when value =1.

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.