Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    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