Forum Discussion
DAX And Conditional Format
Hi Anonymous ,
// Calculation error in measure 'CallData'[Conditional Format]: Cannot convert value "::" of type Text to Type number.
Please use 'CallData'[AvgAnsTime] instead of 'CallData'[Avg Ans Time (Mins)].
'CallData'[AvgAnsTime] return a number value but 'CallData'[Avg Ans Time (Mins)] returns a text value, which can't be used in Maths functions.
Try this:
color = IF ( 'CallData'[AvgAnsTime] > ( 15 * 60 ), "#ff0000")Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I'd probably do something in this nature:
ConditionalFormattingMeasure = VAR minutes = ROUNDDOWN( MOD ( 'CallData'[AvgAnsTime], 3600 ) / 60, 0 ) RETURN IF ( minutes > 15, "#ff0000", BLANK() )
Does this solve the issue? 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Unfortunately not, I did the formula using the columns it says it can not display the visual. (Calculation error in measure 'CallData'[Conditional Format]: Cannot convert value "::" of type Text to Type number.
I also tried something else, but instead of conditionally formatting it, it instead just put "#ff0000" as the record in the table instead of actually coloring it
Hi Anonymous ,
// Calculation error in measure 'CallData'[Conditional Format]: Cannot convert value "::" of type Text to Type number.
Please use 'CallData'[AvgAnsTime] instead of 'CallData'[Avg Ans Time (Mins)].
'CallData'[AvgAnsTime] return a number value but 'CallData'[Avg Ans Time (Mins)] returns a text value, which can't be used in Maths functions.
Try this:
color = IF ( 'CallData'[AvgAnsTime] > ( 15 * 60 ), "#ff0000")Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.