Have a Count measure in the Slicer

[Anonymous]

I have created a count measure in my dataset and given that in a table visual too.

Now I need to make a slicer which has the minimum and maximum range value of the count measure. So that i can use it as a range between filter.

How to do this ? count measure is not getting accepted in the slicer.

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

I am not quite sure if I understood your question correctly, but please check the below picture, measure, and the link down below, whether it is what you are looking for.

Products Count by Range =
IF (
[Products count] >= MIN ( 'Count Range'[Count Range] )
&& [Products count] <= MAX ( 'Count Range'[Count Range] ),
[Products count]
)

https://www.dropbox.com/s/zf6ltczo0yzux80/ramee.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[aj1973]

Hi @Anonymous 

Slicers don't accept measures. maybe you can create a parameter value to navigate between Min and Max of the count.