Forum Discussion
Dynamic Filters
For example, I have a column A with numbers, and I want to calculate +/- X% of Column A. I would like two have two slicers one as a drop for X% (5%, 10%, 15%, etc) and another slicer which will give ...
Anonymous , if the slicer is on % column
measure =
var _max =selectedvalue(slicer[value])
return
calculate(sum(Table[A])*(1+_max))
Absolute number
measure =
var _max =selectedvalue(slicer[value])
return
calculate(sum(Table[A])*((1+_max)//100))