Need help with Dax/Measure to support dynamic target line

[JadhavVarsha_13]

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)

[Greg_Deckler]

@JadhavVarsha_13 Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[JadhavVarsha_13]

hello @Greg_Deckler 

Thank you response,

Here is the sample of output i am trying to generate,

Bars = Total amount

Line = Target Line, basis to the conditions given above

Sample of data - 

120 Days	Achievable	Week	In Scope/Out of Scope	Amt
<120 Days	IN PROCESS	1	In Scope	1060.67
>120 Days	Achievable	0	In Scope	869.04
>120 Days	Achievable	1	In Scope	188