Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
NBR_22
Frequent Visitor

Calculated Measured based on selected filter

Hello,

I have the following graph, the actual closure % is = [Total Daily Closed]/[Total Records]

NBR_22_0-1688054774050.png

 

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.

NBR_22_1-1688054974409.png

 

Thanks in advanced,

Nicolas Blanco




 

2 REPLIES 2
lucadelicio
Super User
Super User

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


Luca D'Elicio

LinkedIn Profile

Unfortunately, this does not solve my issue.

I have created a new table.

NBR_22_0-1688071585525.png

 

 

 

 

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

NBR_22_1-1688071585477.png

 

 

 

 

Slicer shouldn't filter the selected values. Show only be for the calculation.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.