Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Icon for Helper V rankHelper 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 ...
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. 

Sudhavi_84's avatar
Sudhavi_84
Icon for Helper V rankHelper 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
Icon for Community Champion rankCommunity 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.