Filtering of table values/rows based on a dax measure value

[sswah]

Currently I have a table of values

 for .e.g

Column A	Column B
aaaa	0
bbbb	1
ccccc	2
ddddd	3

And I also have a DAX Measure (Measure AA) that returns a single value of a number for e.g. 2 . This number will change accordingly based on certain formula of clicking on various other charts on the dashboard 

My challenge now is , how do i filter the table on top, to only display all records where column B is less than or equal to <Measure AA>. I tried to create a calculated column to return true/false based on each row , to give me if it's less or equal to <Measure AA> but it gave an error that it must be aggregated .

[sswah]

Thanks!

[Gabry · Accepted solution]

I think you could do this with a measure:

filtermeasure = if(selectedvalue(columnb)<=<Measure AA>,1,0)

Then put this measure on the filter pane and select = 1