Dynamic constant line based on different values with slicer

[naresh_nsn]

Hello Experts,

Tried to find many ways but nothing helped yet, would need help on dynamic contatnt line based on values of a column and a slicer selected.

Snap attached, the requirement is , 

 Slicer/Filter - Domain Column
Stack Chart of - Metric column, Provided we already have a stack chart prepared, just need to add the dynamic constant line for showing the targets
Contant line - Target 2021 column

For example, If i select Domain= A, for Test Auomation stcack chart the Target line should show as 23 and for Car Automation stcack chart the Target line should show as 45

Thanks in advance

[amitchandak · Accepted solution]

@naresh_nsn , Create a measure and use that in Analytic pane in visualization -> contact line -> Fx and choose measures

Test Automation = calculate(sum(Table[Value]), filter(Table, Table[Metric]=" Test Automation"))

[naresh_nsn]

Thanks @amitchandak , with some small changes it's working now.