Forum Discussion

jondurbridge's avatar
jondurbridge
Icon for Helper I rankHelper I
7 years ago

Apply A Slicer Directly To A Measure

Hello   I would like to know if I can apply a slicer directly to a measure? I have 2 slicers which apply to a whole report, and I have 2 measures in a line graph. But I do not want the slicers to ...
Need Help
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
7 years ago

You can use selectedvalue

 

Measure =
VAR Slicer1 = SELECTEDVALUE(Table1[Date Opened], "something if not true")
return
CALCULATE([Measure], Table1[Date Opened] = Slicer1)
  • jondurbridge's avatar
    jondurbridge
    Icon for Helper I rankHelper I
    7 years ago

    Thanks 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

    • hnguy71's avatar
      hnguy71
      Icon for Super User rankSuper User
      7 years ago
      Count 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's avatar
        jondurbridge
        Icon for Helper I rankHelper I
        7 years ago

        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?