Forum Discussion
Helper IApply A Slicer Directly To A Measure
Helper IThanks for the quick reply..
Could you tell me how to do it for this data?
Table is Query1
ticket opened is create_time
ticket closed is date_completed
slicers are create time and date completed
So how would I create a measure for count of Query1[date_completed] by slicer date completed?
Thank you
Super UserCount Completed Based On Date = var DateSelected = SELECTEDVALUE(Query1[date_completed]) return CALCULATE(COUNT(Query1[date_completed]), Query1[date_completed] = DateSelected)
I think this is what you're asking for....
However, you can really just do a count for date_completed and the slicer should automatically filter out for that specific date
- jondurbridge
The problem is
Create_time is a date, and Date_completed is a date
I do not want the value of create_time to be affected by the slicer for date_completed, and vice versa
I cannot see anything in the propsed solution which tells the measure to be filtered by a specific splicer?
- hnguy71
You can change each slicer / visual interactions by selecting the slicer and click format. From there, you can choose what your slicer(s) do:
- jondurbridgeThat's just on visuals though isn't it?
I need to change what the slicer does on a measure