Forum Discussion
Calculated Measured based on selected filter
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 a...
ParametricMeasure =
var _tab = VALUES(DATATABLE[day])
var _tab = VALUES(DATATABLE[day])
RETURN
IF(
DATATABLE[day] IN _tab
,MyMeasure ,BLANK()
)
Set the visual to show also point without values.
Sign as solution if it helps.
Ciao
Set the visual to show also point without values.
Sign as solution if it helps.
Ciao
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.