Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |