Forum Discussion
Measure as a drop down slicer
Hi,
There is a measure "TotalCost" which used in table visual along with few other columns. I want to filter the table visual by using the same measure in dropdown slicer with multiselect opti...
Anonymous Please try this one:
Slicer Measure = VAR Table1 = SUMMARIZE( Product, Product[ProductName], Product[ProductNumber], "TotalCost", [TotalCost] ) RETURN Table1
Measure Filter =
VAR SelectedTotalCosts = VALUES('Slicer Measure'[TotalCost])
VAR CurrentMeasureValue = [TotalCost]
RETURN
IF( COUNTROWS
( FILTER
( SelectedTotalCosts, CurrentMeasureValue = [TotalCost] )
) > 0, 1, 0 )