Need help with Dax/Measure to support dynamic target line
Hello All, Need help with Dax craetion, Any help would be appreciated. below is case or condition we have, this is i need to pass as a line or secondary Y axis to the combo chart (bar + line combo) I have tried multiple ways but some how the line is not passing through. tried using switch, or, and. I have week column, which holds values like, week 0, week 1, week 2...... below is the problem statement : End of Month Target: Achievable: Min of (Total in-scope open orders for the given Market at Week 0 * 30% or Achievable> 120days at Week 0) IN PROCESS: Min of Total in-scope open orders for the given Market at Week 0 * 30% or IN PROCESS > 120days a Week 0 Weekly Target Achievable: If Achievable> 120days at Week 0 < Total in-scope open orders for the given Market at Week 0 * 30%: Target is flat line at: Total in-scope open orders for the given Market at Week 0 * 30% If Achievable> 120days at Week 0 > Total in-scope open orders for the given Market at Week 0 * 30%: The Weekly target should be a linear line from * Week 1 target for *Achievable> 120days*: Achievable> 120days at Week 0 - 1 *(Achievable> 120days at Week 0 - Total in-scope open orders for the given Market at Week 0 * 30%/4) Week 2 target for *Achievable> 120days*: Achievable> 120days at Week 0 - 2 *(Achievable> 120days at Week 0 - Total in-scope open orders for the given Market at Week 0 * 30%/4)