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

Instead of using [Parameter Value], use Parameter[Parameter].  You want to take the MIN and MAX of the column, not use the measure.

Regards,

Pat

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

Hi mahoneypat 

 

Can you please take a look at the pbix? I did the dax measure but not sure I understand the concept. I apply the filters with the parameter but the table doesn't update.

 

Also a question I have is why I should I use an average in that dax measure?

 

pbix https://1drv.ms/u/s!ApgeWwGTKtFdhzdufgkRUs0RVGxd?e=2L8YPi

 

Thank you for your help!