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)
cummulative value without affected by slicer
Hello There I need some help with my report. i have two tables in excel which is as my source of my BI report. one contain dates, monthly achievement, running cummulative monthly achievement, monthly target and running cummulative monthly target, and the other one is only list of dates. this table of list of dates is used as slicer to filter many charts within my BI report. so these tables have connections in my BI between dates on list of data to dates on list of dates the report is like this picture below, the slicer that contains name of month data came from table list of dates (as i mentioned earlier, this slicer is to filter many chart in one report page), and the combo chart data came from table list of data. line chart is cummulative target, and bar chart is cummulative monthly achievement i want to slice the chart by slicer on the above but only affect to the cummulative monthly achievement (bar chart), for instance, if i click month of january on the slicer, the bar chart should show only for january, and the february one is not shown, and so on, and the line chart should remain the same, still showing from month of january to december (not affected by slicer's filter). maybe there's some DAX or measures required to do this, i've try to make simple measure which calculate monthly achievement to running total (like using calculate, sum, filter etc.), but still not working as i wanted. the slicer keep slicing line chart what i expected after i do some slicer filter is like this (this is easy in excel) please if anybody in this forum can help me Thank you BI Forum
