Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

How to create one silcer for multiple 2 columns

Hi all   I would like to have a "between" slicer that contains two columns (min velocity, max velocity).   What I did in order to try to solve this, was creating a new table:   Table = DISTIN...
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please use this variation instead.  It returns 1 or 0, and can be added to the Filters on this visual and set to 1.  Note that it requires that the min velocity is above the lower end of the filter and max is below the upper end.

     

     

    IsInRange = if(AND(AVERAGE(Equipment_database[MinVelocity])>=MIN(Parameter[Parameter]), AVERAGE(Equipment_database[MaxVelocity])<=MAX(Parameter[Parameter])),1,0)
     
    Regards,
    Pat

     

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago

Awesome mahoneypat 

 

Almost there. Just one question, how can I make that measure called "IsInRange" filter all the page ?

 

I drag the measure to the "filters on this page" but wont work. It is possible only to drag the measure to each visual created?

 

Thanks!

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Yes. Measures can only be used in visual filters

Pat