Forum Discussion
Compare a measure with column values and conditional format
Hi all, Below is a view that I bring in to a 'table view' in PBI. 'Current_Value' (Table A) is a measure and 'HI HI(red)' (Table B) is a columnar value. I want a logic that compares If Current_Va...
Hey,
from my understanding you should rewrite the measure like so:
Conditional_Value = If(HASONEVALUE('Table A'[NAME]), IF( [Current_Value]>SUM('Table B'[HI HI (red)]) , "#FF0000" , "#008000" ) )Regards,
Tom
TomMartens
Super User
Super UserHey,
from my understanding you should rewrite the measure like so:
Conditional_Value = If(HASONEVALUE('Table A'[NAME]),
IF(
[Current_Value]>SUM('Table B'[HI HI (red)])
, "#FF0000"
, "#008000"
)
)
Regards,
Tom
My god! That was literally my first attempt, but I was formatting it incorrectly!! Thank you so much!!
- TomMartens
:smileywink: