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 ForumFilter a table then rank
Please help. I don't know how to do this and I keep going down rabbit holes. I have a fact table, "Incidents", that contains column "Inc_CI_Service". I have a measure, "PM Count", that gives me the count of tickets for each CI Service for last month. I have another measure called "Trigger" that returns 1 if PM Count is greater than a variable or 0 if it is not. I need a formula or set of steps to take to filter the list for Trigger = 1 and then Rank the resulting list/table. Right now, RankX ranks the whole table but I need it to rank the filtered table. I'm assuming it would involve the creation of a vitual table within the formula that ranks the results but I'm stuck on how to do that. At this point, I can't even figure out how to create a filtered table based on 1 column and two measures. Please help.
