Forum Discussion
Post ProdigyHow to create one silcer for multiple 2 columns
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
Microsoft EmployeeYou don't need your union table for that. You can just use a What-If Parameter or make a DAX table with
SlicerValues = GENERATESERIES(0, 30000, 1000)
Use it in your slicer and you can then make a measure like this
IsInRange = OR([AverageMinVelocity]>=MIN(SlicerValues[Value]), [AverageMaxVelocity]<=MAX(SlicerValues[Value])
It will return true or false and you can use it on the Filter panel as a filter on one or more of your columns in the visual (column name isn't shown in your pic).
Regards,
Pat
Post ProdigyHi mahoneypat the problem is that the parameter will have fixed limites defined at the very start.
The advantage of the table is that it will be dynamic and therefore updated regardless of the min and max entered.
Would it be possible to create a dax measure to have what i'm looking for with the new table?
Thanks!
- mahoneypat
Yes. You could use MIN and MAX as well like
SlicerValues = GENERATESERIES(MIN(Equipment_database[MinVelocity]), MAX(Equipment_database[MaxVelocity]), 1)
If you want to increment by more than 1, you could use the ROUND(MIN(...), -2) to get each value to the closest 100.
Regards,
Pat
- o59393
Hi mahoneypat
I have the parameter:
The second step I guess is create the dax measure you stated before. I tried:
How can I get it right? and how should I use this measure with the parameter created?
Thanks!- mahoneypat
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