Filter based on a existing measure.

[Anonymous]

I have a measure that is created to calculate the number of years from the time an asset is purchased. 

Warranty in Years = CALCULATE(DATEDIFF(SELECTEDVALUE('Configuration Item'[PAR/PO/EP Date]),TODAY(),MONTH))/12

This is giving me the desired results. 
However, when i try to use the measure in a filter to calculate assets greater than 5 years old it gives an error: 

Dax to calculate out of warranty

Out of warranty = CALCULATE([Configuration Item Count],[Warranty in Years]>5)

 Please can someone help ? 

[Anonymous]

Thanks So much, John 🙏

[johnt75 · Accepted solution]

You can't use a measure as a filter in calculate, try

Out of warranty =
COUNTROWS ( FILTER ( 'Configuration Item Count', [Warranty in Years] > 5 ) )