topic Re: Need help with Dax/Measure to support dynamic target line in DAX Commands and Tips

Need help with Dax/Measure to support dynamic target line

JadhavVarsha_13 — Sat, 23 Mar 2024 06:30:07 GMT

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 — Sat, 23 Mar 2024 13:35:35 GMT

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 — Sun, 24 Mar 2024 23:38:10 GMT

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 -