Multiple goal lines dependent on selection in slicer

[jcastr02]

I am needing a visual that will show average handle time by employee tenure, and by training type.   We have two different call types as well so I have a filter on the report page, and I would like the goal line to change based on the call type selected.   I have a measure created to move the goal line based on the "call type" (see below).  Right now I only have a line graph as I'd like to have each line represent the different "training types" , x axis - employee tenure and y - axis the handle time.  I can add a constant line but will not allow it to change based on the call type selection.  I also tried dropping the measure "goal AHT" into the values field but it doesn't let me have multiple values for line values

[v-xicai]

Hi @jcastr02 ,

You can create measure like DAX below, then put the new measure [AHT_Sum] into Values box of Line chart to replace the [AHT].

AHT_Sum= CALCULATE(SUM('OPS Performance'[AHT]), ALLSELECTED('OPS Performance'))

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tex628]

For this to work in your visual you will need to make seperate measures for each training type. Then remove the legend and add all measures to the values.

On Demand = Calculate( [AHT] , 'Table'[Training Type] = "On demand" )

Trainer Led = Calculate( [AHT] , 'Table'[Training Type] = "Trainer Led" )​

Goal = 
Switch(SelectedValue('Table'[Call Type) ,
"SAT Enrollment" , 104 ,
"SAT Refill Confirmation" , 99
)

[jcastr02]

@tex628   Hi there, thanks for help, when I am trying to input formula, the AHT portion is not recognized.  I have already converted it to number columns in modeling, but it doesn't recognize the AHT column.  

[tex628 · Accepted solution]

I didn't notice that AHT was a field!

 
In that case you need to perform an aggregation, like this:

On Demand = Calculate( Average('Table'[AHT]) , 'Table'[Training Type] = "On demand" )

[jcastr02]

@tex628 This worked! thank you!!!