Selected value in calculated column

[amaniramahi]

I have a table contains the following sample data (Sensors Table)

Date	Time	RPM
15/3/2020	1:00 PM	1000
15/3/2020	1:02 PM	1200
15/3/2020	2:07 PM	1300
16/3/2020	11:40 AM	2500
16/3/2020	12:30 PM	680

and another table contains the following sample data (Trip table)

Trip Number	Date	From	To
Trip1	15/3/2020	12:00 PM	1:30 PM
Trip2	15/3/2020	2:00 PM	4:00 PM
Trip3	16/3/2020	8:00 AM	1:00 PM

and a what if parameter (Acceleration %) for the values of RPM

what I need to calculate is the count of times where RPM exceeds the selected value in the what-if parameter

as long as it's the same date and during the trip interval.

whenever I create a calculated column using SELECTEDVALUE it does not return the correct value.

[parry2k]

@amaniramahi you have to use selectedvalue in a measure, not calculated column.

[amaniramahi]

@parry2k  I know. that's why I am asking if there's a way to do what I want without using SELECTEDVALUE

[parry2k]

@amaniramahi question I would ask why you want o create a calculated column not measure?

[amaniramahi]

I tried, I wrote the following formula

Measure = 
var _SelectedAcc = SELECTEDVALUE('Over Revving Parameter'[Over Revving])
var _Qty = CALCULATE(COUNT(Sensors[RPM]),FILTER(Sensors,Sensors[Date]=

 then I stop and I cannot select the date in Trip table.

and I guess I won't be able also to add filters for time.

Btw, there is a third table contains date column and they are all related. 

[parry2k · Accepted solution]

@amaniramahi well, it's not as straight forward, there are many moving parts, based on what you posted and what I understood, I created a work file (attached), take a look and adjust according to your requirement.

I'd like to💖 Compliments🙂 if my solution helped me.👉If you can spend time posting the question, you can also make efforts to give Kudos who has helped solve your problem. It's a token of appreciation!

[amaniramahi]

Thank you, but the problem is the formula summed the RPM readings.

I have 5 different readings, and I need to check for every single reading if it exceeds the What-if parameter or not (not to check if their summation exceeds).

but did a little tweak on your  formual and it worked!

Thank you so much