Forum Discussion
sudhakar111
Helper IV
Helper IVDays Bracket Filter in Report
Dear All, I need help in creating a days bucket formula, which will be used in the report as a filter. Below is the code i wrote.The problem with this is when bracket 30 is selected it shows ...
You cannot do that by creating a calculate column using IF(). Try the following method:
1. Create a "Slicer Table" with Enter Data, enter value, 7,30,60.
2. Create a measure.
Measure = CALCULATE(MAX([Date_Condition]),FILTER('Table',[Date_Condition]<=SELECTEDVALUE('Slicer Table'[Slicer])))
3. Create a slicer with the Slicer column from the new table to filter.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sudhakar111Anonymous Created the measure and slicer. When a range is selected in the filter it is also displaying other ranges,and they are showing as empty. When a selection is made, other ranges should not be displayed on the table.