Evaluate a text composed expression as DAX espression

[kwouter1]

I am trying to build a generic Red Amber Green evaluation

For simplicity reasons I limit the example to Red

I use following calculated column to put a "R" (from Red) in a field ( which I will later transalate to a hex Red color code and then based on this value use conditional color coding to color code my reports.

RED_TH=          0.9     ( red threshold)

RED_SIGN=       <   (operator I want to use)

RAG2 =

var RED_TH=LOOKUPVALUE(TARGETS[RAG_RED_TH],TARGETS[PLATFORM],MSR[PLATFORM],TARGETS[METRIC],MSR[Metric])

var RED_SIGN=LOOKUPVALUE(TARGETS[RAG_RED_SIGN],TARGETS[PLATFORM],MSR[PLATFORM],TARGETS[METRIC],MSR[Metric])

//below I construct the expression, pls notive that the field ACTUAL in table MSR where i create the formula is containing the actual result I want to evaluate versus target

var expressionRED="MSR[ACTUAL]" & RED_SIGN & RED_TH

//Above would result in MSR[ACTUAL]<0.9

return

//then try to evaluate the constructed expression as part of if statement

IF(expressionRED,"R","")

I always get the error "Cannot convert value '<0.9' of type Text to type True/False."

Hope anyone can help me to convert the constructed to a DAX expression. Thnx for help, Koen

[V-lianl-msft]

Hi @kwouter1 ,

Please follow the error message for troubleshooting "Cannot convert value '<0.9' of type Text to type True/False."

If the problem persists,could you share the sample pbix via cloud service like onedrive for business?

Please remove any sensitive data before uploading.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kwouter1]

Thank you sir, I indeed tried that but same result, if i levae the quote away rightfully the expression is there but still sees it as a text, but actually right quote should not be there. Thnx will need to continue to look

[amitchandak]

@kwouter1 , I think this should be without doublr quote

var expressionRED=MSR[ACTUAL] & RED_SIGN & RED_TH

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.