topic Re: Filter based on a existing measure. in DAX Commands and Tips

Filter based on a existing measure.

Anonymous — Tue, 21 Feb 2023 07:30:20 GMT

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 ?

Re: Filter based on a existing measure.

johnt75 — Tue, 21 Feb 2023 09:27:07 GMT

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

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

Re: Filter based on a existing measure.

Anonymous — Tue, 21 Feb 2023 10:28:57 GMT

Thanks So much, John 🙏