DAX Measure error consider using Values or Format

[Anonymous]

Hi Experts

Getting the following DAX Measure error cannot see my mistake...

Note the column [RenewalFlasg] is a True/false column in my table

Annuity New = CALCULATE([Monthly Total Switch],FILTER(FACT_NEWBI_NewSalesDashboard,FACT_NEWBI_NewSalesDashboard[OrderType] IN {"Managed Services", "Flex", "Vouchers", "Maintenance"} && FACT_NEWBI_NewSalesDashboard[RenewalFlag] = "FALSE"))

[johnt75 · Accepted solution]

Try changing "FALSE" to FALSE(). You are trying to compare a boolean value with a text string.