Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
I have the following graph, the actual closure % is = [Total Daily Closed]/[Total Records]
There's a scenario planning which is based "What if parameter"
What I'm trying to accomplish here, is that based on the day selected calculate the scenario planning only for the day selected, so the graph should show all the days of the week overlapping and the new scenario % point out based on Selection in the filter.
Thanks in advanced,
Nicolas Blanco
Unfortunately, this does not solve my issue.
I have created a new table.
New SR Daily Closure is based on the "What If Parameter"
I need a measure to calculate the Scenario Planning only based on the selected slicer below :
Closure % = DIVIDE([Total Daily Close],[Total_Records])
Scenario Planning Closure % = DIVIDE([New SR Daily Closed],[Total_Records])
So the time series will show the Scenario Planning for the days selected, but It will overlap the not selected values. For Example, If I select Monday and Tuesday, I should see the spikes for those days and the other days (Wedsnesday, Thursday, Friday.....) should be the same as Closure %.
Slicer shouldn't filter the selected values. Show only be for the calculation.