Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Shadaiv
Helper II
Helper II

How to use DAX measure in between slicer

Hi all, 

Need your help here.

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

Shadaiv_0-1656337827162.png

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 

 

2 REPLIES 2
amitchandak
Super User
Super User

@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) )

 

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.