Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Can you share sample data and sample output in table format?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Would this suffice amitchandak ?

     

     

    A+10%-10%
    10119
    20

    22

    		18
    303327

     

     

     

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      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))