Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |