Conditional formatting in Dax Error (comparison T/F to Number)

Question

Hi all,&nbsp;I am making a measure based off a filtered visual on the dashbaord so it gives a grade. I made the measure to get the information from the visual I need help getting the conftional formatting correct becsue I get this error.&nbsp;&nbsp; &nbsp;" MdxScript(Model) (16, 13) Calculation error in measure 'COAParameterRawScore[Measure]: Dax comparison operations do not support comparing values of type True/False with values of type Number. Consider using the VALUE or FORMAT function to convert one of these values.&nbsp;&nbsp;here are the code slices:MEASURE = IF (&nbsp; &nbsp; 92.5&nbsp;&lt;[Filter],&nbsp; &nbsp; "A",&nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; 85&nbsp;&lt; [Filter] &lt;= 92.5,&nbsp; &nbsp; &nbsp; &nbsp; "B",&nbsp; &nbsp; &nbsp; &nbsp; IF (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 77.5&lt; [Filter] &lt;= 85,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "C",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "D"&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))&nbsp;&nbsp;Filter =&nbsp; &nbsp; VAR __DS0FilterTable = &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(VALUES('vExternalNOTRManagementList'[ClientName])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'vExternalNOTRManagementList'[ClientName] IN {"Starbucks"},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'vExternalNOTRManagementList'[ClientName] IN {"Starbucks"}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; VAR __DS0FilterTable2 = &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KEEPFILTERS(VALUES('vExternalNOTRManagementList'[DateSent])),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'vExternalNOTRManagementList'[DateSent] &gt;= DATE(2024, 8, 1),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'vExternalNOTRManagementList'[DateSent] &lt; DATE(2024, 9, 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; VAR __DS0FilterTable3 = &nbsp; &nbsp; &nbsp; &nbsp; TREATAS({"Pactiv LLC"}, 'vExternalNOTRManagementList'[SupplierName])VAR __Result = CALCULATE(AVERAGE('COAParameterRawScore'[Total Product Performance]),__DS0FilterTable3,__DS0FilterTable2,__DS0FilterTable)RETURN__Result&nbsp;&nbsp;Any and all help is appericated. 🙂

rajendraongole1 · Accepted Answer

Hi&nbsp;BigESloth&nbsp;- can check below measure:
MEASURE =IF ([Filter] &gt; 92.5, "A",IF (AND([Filter] &gt; 85, [Filter] &lt;= 92.5),"B",IF (AND([Filter] &gt; 77.5, [Filter] &lt;= 85),"C","D")))
hope it works, if any please share sample data or pbix file for reference.

Forum Discussion

Conditional formatting in Dax Error (comparison T/F to Number)

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Condition formatting

Conditional Formatting