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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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

 

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.