Forum Discussion

NBR_22's avatar
NBR_22
Frequent Visitor
3 years ago

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 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




 

Need Help
Tips and Tricks

2 Replies

  • lucadelicio's avatar
    lucadelicio
    Impactful Individual
    3 years ago
    ParametricMeasure =
    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
    • NBR_22's avatar
      NBR_22
      Frequent Visitor
      3 years ago

      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.