Forum Discussion

shyammayhs's avatar
shyammayhs
Icon for Advocate II rankAdvocate II
4 years ago

Dropdown filter with greater than options

Hi all!

 

I am trying to achieve something which I can't get my head around!

 

I would like to have a dropdown filter with values, for example, >5%, >10%, >15%, >20% etc.
Where if I select >5%, it should show all of the values that are greater than 5%. And If I select >15%, it should include all values greater than 15%.

Is this something that is possible to do?

 

Thanks.

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    shyammayhs , Create a table like this

     

    Tab= Addcolumns( generateseries(1,100,5) , "Bucket", " > " & format([value], "00") )

     

    then select bucket in slicer

     

    create a measure like

    measure =

    var _1 = maxx(allselected(Tab), Tab[value])

    return

    calculate(sum(Table[Value]), filter(Table, Table[Value] >_1/100))

    • shyammayhs's avatar
      shyammayhs
      Icon for Advocate II rankAdvocate II
      4 years ago

      amitchandak, thanks for your reply.

      Could you explain how the measure works? Where should this be applied? what should I be doing the sum of?

       

      Thanks.

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        shyammayhs ,If this does not help
        Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.