Filtered Table in a Visual

[BrianJ]

@cleverclog,

Great – glad that got you what you needed.

I can see why you ran into trouble trying to do this without the use of the filter pane. The humble filter pane definitely does not get enough respect. Check out the post below as proof -

using the filter pane - 1 line of DAX
not using the filter pane – 59 lines of complex DAX

What if parameter not working

@bgood, Sure – I love this stuff, so always happy to write a bunch of DAX. [image] This should provide some much-needed respect for the humble visual-level filter though: With visual filter - DAX measure: 1 line Without visual filter - DAX measure: 59 lines Here’s the measure: Total Sales LT Threshold = VAR Threshold = 2500 VAR vTable = ADDCOLUMNS( CROSSJOIN( VALUES( Customers[Customer Name] ), VALUES( Products[Product Name] ) ), "TotSales", [Total …

• Brian