Filtering a Table Based on Slicer Selection in Power BI

[Anonymous]

Hi Everyone!!!

I have a table with two columns: 'Column1' (text) and 'Column2' (decimal). I also have a slicer based on 'Column1'. How can I use DAX to filter the table in the following way: when a value is selected in the slicer (e.g : 'B'), the table should only show rows where 'Column2' is greater than the selected value?

Table
Column1 Column2
A             100
B              300
C              600
D             200
E              500

Output:
Column1 Column2
C              600
E               500

How can we achieve this filtering in Power BI

[olgad · Accepted solution]

Hi @Anonymous , duplicate your table, make sure, there is no relationship between the two tables.

Measure = Calculate(Sum(Table[Column2]), Filter(Table, Table[Column2]>SELECTEDVALUE(Slicer[Column2])))

Table is the original Table, Slicer is the same table, disjointed, no relationship