Forum Discussion
Solved
Slicer threshold based on raw column value
Hi, Is it possible to create a threshold slicer based on a raw column value? I have a column with values [10,20,30,40,50,60]. I want to create a slicer such that the value selected capture ev...
swong,
Firstly, create a calculated table using the DAX below.
ValueTables = VALUES(Table[Column1])
Secondly, create a measure in your original table.
expectedresult = CALCULATE(SUM(Table[Column1]),FILTER(Table,Table[Column1] >= FIRSTNONBLANK(ValueTables[Column1],1)))
Thirdly, create a slicer using the column of the newly created table.
Regards,
Lydia
