Dax measure not working

[Dallas7890]

Hello,
I am hoping that someone can help me to write or fix this  Dax measure. I am trying to calculate the Sum of Hours based on two column filters. The Table is called Leave Balances FY Financial Accruals
and the first column is called Time Off Plan details = "Total Balance Remaining" and the second column is called Time Off Plan = "Time in Lieu" - it returns a blank value. However if I just filter the values manually under the filter pane and use just the Total Hours measure or just put the Total Hours in a card it returns a value. 

Filtered Hours Sum =

CALCULATE(

    SUM('Leave Balances FY Financial Accruals'[Total hours]),

    'Leave Balances FY Financial Accruals'[Time Off Plan details] = "Total Balance Remaining",

    'Leave Balances FY Financial Accruals'[Time Off Plan] = "Time in Lieu"

)

Thank you kindly

[bhanu_gautam · Accepted solution]

@Dallas7890 , Try using below measure

Filtered Hours Sum =
CALCULATE(
SUM('Leave Balances FY Financial Accruals'[Total hours]),
FILTER(
'Leave Balances FY Financial Accruals',
'Leave Balances FY Financial Accruals'[Time Off Plan details] = "Total Balance Remaining" &&
'Leave Balances FY Financial Accruals'[Time Off Plan] = "Time in Lieu"
)
)

[Dallas7890 · Accepted solution]

I figured out my problem - There was white space in front of each value from the Time Off Plan details. Thank you but this has been resolved. 

[Dallas7890 · Accepted solution]

I figured out my problem - There was white space in front of each value from the Time Off Plan details. Thank you but this has been resolved. 

[Dallas7890 · Accepted solution]

Thank you for helping me to correct my measure Bhanu. I thought it was just because of the white space only. 

[bhanu_gautam · Accepted solution]

@Dallas7890 , Try using below measure

Filtered Hours Sum =
CALCULATE(
SUM('Leave Balances FY Financial Accruals'[Total hours]),
FILTER(
'Leave Balances FY Financial Accruals',
'Leave Balances FY Financial Accruals'[Time Off Plan details] = "Total Balance Remaining" &&
'Leave Balances FY Financial Accruals'[Time Off Plan] = "Time in Lieu"
)
)