Forum Discussion
How to capture the lower and upper user input for a Between Filter
Hello Group,
So i have a situation where i have a Between Filter on one of my measure column on my Report page....in that measure, values range from $5 to $50000.
User uses the between filter to see the amounts only between $0 and $500. This is working fine.
Now, on my report as a header i need to show the Filters applied. where i want to show that RANGE SELECTED BY USER is between $0 and $500.
now if i use MIN(measure column) and MAX(measure column) function, they dont serve the purpose as these return the MIN and MAX values in the column after the filter not the MIN and MAX values entered by user.
Is there anyway to handle this.
Thanks in advance
Hi poojawadhwa
It’s impossible to return a value that is typed in but does not exist in the Entity Data table.
If you want to return 0 and 500, it's necessary for your measure to be able to return these 2 values.
For example, here I have a table:
When I apply a filter(30-100), I can get the max value 100 and the min value 57, because the measure have the 100 output but without a 30 output.
Here is a alternative workaround for your reference:
Add a table to control the scope and create a slicer with this field:
Add one measure to replace the measure in the table visual and 2 measures to get the slicer range:
MEASURE 2 = IF ( [Measure] >= MIN ( 'Table 2'[Value] ) && [Measure] <= MAX ( 'Table 2'[Value] ), [Measure] )Range_Min = MIN('Table 2'[Value])Range_Max = MAX('Table 2'[Value])The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- Ritaf1983
Super User
Hi poojawadhwa
please share a pbix or some dummy data (not as a screenshot) that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
- elitesmitpatel
Solution Supplier
please share a pbix or some dummy data
Hi poojawadhwa
It’s impossible to return a value that is typed in but does not exist in the Entity Data table.
If you want to return 0 and 500, it's necessary for your measure to be able to return these 2 values.
For example, here I have a table:
When I apply a filter(30-100), I can get the max value 100 and the min value 57, because the measure have the 100 output but without a 30 output.
Here is a alternative workaround for your reference:
Add a table to control the scope and create a slicer with this field:
Add one measure to replace the measure in the table visual and 2 measures to get the slicer range:
MEASURE 2 = IF ( [Measure] >= MIN ( 'Table 2'[Value] ) && [Measure] <= MAX ( 'Table 2'[Value] ), [Measure] )Range_Min = MIN('Table 2'[Value])Range_Max = MAX('Table 2'[Value])The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
