Calculated Field formula doesn't work as intended

Question

eGFR Months = DATEDIFF(app_appointments[eGFR_test_date],TODAY(),MONTH)

Age = FLOOR(IF([dob]< TODAY(), DATEDIFF([dob], TODAY(), DAY) / 365.25, 0), 1)

i have two calculated fields in different tables defined as above - these work fine on their own

trying to get a formula below to work : ie anyone over 70 who have not had an eGFR recently needs a blood test.

Blood Test =

var _t1 = SELECTEDVALUE(app_patient_details[Age])

var _t2 = SELECTEDVALUE(app_appointments[eGFR months])

return

IF( (_t1 >69 && _t2 > 0), "Blood Test","Not Working")

But the formula always returns false even if i change to

Blood Test =

var _t1 = SELECTEDVALUE(app_patient_details[Age])

var _t2 = SELECTEDVALUE(app_appointments[eGFR months])

return

IF( (_t1 =70), "Blood Test","Not Working")

or

Blood Test =

var _t1 = SELECTEDVALUE(app_patient_details[Age])

var _t2 = SELECTEDVALUE(app_appointments[eGFR months])

return

IF( t2 > 0), "Blood Test","Not Working")

aany ideas? thanks

amitchandak · Answer

cheezy , you need row value then it should be the max not selected value.
Please find one formula changed
&nbsp;
Blood Test =IF( (max(app_patient_details[Age]) &gt;69 &amp;&amp; max(app_appointments[eGFR months]) &gt; 0), "Blood Test","Not Working")

farhanahmed · Answer

Hi&nbsp;cheezy&nbsp;SelectedValue works when you have column returns 1 value from column. If your column is aggregating , lets say 71 is for multiple people on given selection it will return NULL value and hence your if statement will never get true and returns "Not Working"&nbsp;See screenshot for the reference.&nbsp;You might need to use other aggregate function or include further granuality on your table selection to have desired results.&nbsp;Regards