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

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
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