How to use DAX measure in between slicer

[Shadaiv]

Hi all, 

Need your help here.

I have a requirement to use a measure value in between Slicer visual. 

Can we acheive this? I don't think this can be done by the default slicer visual. Is there any custom visual which allows us to add a DAX measure value. 

Thanks 

[amitchandak]

@Shadaiv , Try a measure like

Filter a column =
var _max = minx(allselected(Slicer), Slicer[value])
var _min = maxx(allselected(Slicer), Slicer[value])
return
calculate(countrows(Table), Filter(Table,(Table[value] <=_max && Table[value]) >=_min) )

filter a measure

Filter a column =
var _max = minx(allselected(Slicer), Slicer[value])
var _min = maxx(allselected(Slicer), Slicer[value])
return

calculate(countrows(Table), Filter(Table,([measure] <=_max && [measure]) >=_min) )

or

calculate(countrows(Table), Filter(values(Table[Column]) ,([measure] <=_max && [measure]) >=_min) )

[Shadaiv]

Hi @amitchandak 

Thanks Amit for your reply.

Sorry, can i please ask for more details?

I have DAX measure called Total Sales = SUM(SalesFact[SalesAmount])

How can i create a slicer for this.

Thanks