Filtering a Table Based on Slicer Selection in Power BI

Anonymous — Thu, 07 Mar 2024 12:38:11 GMT

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

Re: Filtering a Table Based on Slicer Selection in Power BI

olgad — Thu, 07 Mar 2024 13:22:33 GMT

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

topic Re: Filtering a Table Based on Slicer Selection in Power BI in DAX Commands and Tips

Filtering a Table Based on Slicer Selection in Power BI

Re: Filtering a Table Based on Slicer Selection in Power BI