Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Helper V
5 years ago
Solved

Measures filter

Hi Experts,

 

I have a visual and filter(list of project's).

I can select the projects and visual will update which is perfect.

 

I have measure which calculates values of each project. 

 

My question is, I am trying to populate list of project's in drop-down which has project value between 0 and 10000 only.

 

I don't want to include all projects in drop-down filter. However, I cannot drag measures in to drop-down and filter with specific range.

 

How can I do it to populate only list of project's in drop-down which has value between 0 and 10000?

 

Any advice please?

 

Need Help
  • edhans's avatar
    edhans
    5 years ago

    yeah, you can create a user-selected parameter via the Modeling tab, New Parameter. Then use SELECTEDVALUE() in a measure to see what the user has selected, and in turn, use that measure as a filter measure. 

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Sudhavi_84 

     

    What I would suggest doing is to use the measure as a filter in your visual and that should allow you to get to what you are looking for?

    • Sudhavi_84's avatar
      Sudhavi_84
      Helper V
      5 years ago

      Hi GilbertQ ,

       

      Thank you for the response.

      But will it show in filter those projects only with in range specified in visuals?

       

      This didn't worked for me any screenshot please if possible.

       

      Thank you for your help

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        See this image. You can put measures in filters for visuals only, not pages, nor entire report. By setting the visual filter for the total measure to just between 3 and 7, only products C, D, E, F, & G show up. A, B, and H are not in the slicer, because their sales are 1, 2, and 9 respectively, outside the 3-7 range.