Forum Discussion

JadhavVarsha_13's avatar
2 years ago

Need help with Dax/Measure.

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)

 

 

1 Reply