Create a filter of a numeric/economic measure

[Syndicate_Admin]

Good morning

I have a report with calculated economic measures of this kind.

Sales Consumption = SUM('AACT TICKETS')

And I would like to create a filter in the report on some of these measures of this kind.

When I drag the measurement to the filter object it does nothing.

I don't know if anyone can help me.

Thank you.

[johnt75]

You can't use a measure on a slicer, but you could create a workaround. Add a new numeric range parameter with start and end values big enough to cover all the values which your measure could foreseeably return.

Then you could create a new measure to use as a filter, like 

Value is visible =
VAR CurrentValue = [Sales Consumption]
VAR MinSliderValue =
    MIN ( 'Number range'[Value] )
VAR MaxSliderValue =
    MAX ( 'Number range'[Value] )
RETURN
    IF ( MinSliderValue <= CurrentValue && CurrentValue <= MaxSliderValue, 1 )

Add this new measure as visual level filter to only show when the value is 1

[Syndicate_Admin]

Hi how are you, I implemented your solution to my board (thank you very much), but segmentation only affects one object, meaning that when I move the slider, only one object is affected. I added the measurements as visual level filters to the other objects, but it doesn't work. I would like to know if it can be resolved.

1)

2)

Thank you very much in advance

[Syndicate_Admin]

Good I have applied the changes that you have indicated I have the parameter

associated with the filter object

And I have created the measure as you indicate.

Value is visible =

WHERE CurrentValue = [Consumer Sales]

WHERE MinSliderValue =

MIN ( 'Number range'[Number range] )

WHERE MaxSliderValue =

.MAX ( 'Number range'[Number range] )

RETURN

IF ( MinSliderValue <= CurrentValue && CurrentValue <= MaxSliderValue, 1 )

Something that happens to me is that to the extent it does not let me put

MIN ( 'Number range'[Value] )

[johnt75]

OK, the column is called Number Range as well. Just change 'Number Range'[Value] to 'Number Range'[Number Range] in both instances.