Forum Discussion
DAX Measure error consider using Values or Format
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"))
Try changing "FALSE" to FALSE(). You are trying to compare a boolean value with a text string.
1 Reply
Try changing "FALSE" to FALSE(). You are trying to compare a boolean value with a text string.