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

     

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
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

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

OMG.. thank you so much TomMartens. I was trying to develop a flag so I could use the Cell elements, conditional formatting and it worked!!! However, I changed the color hex # w/text  "1 & 2 ",  I have been searching for weeks...  
Can this be a nested for a # 3 if I have blank cells I would like no icon or color???

RATE_WP = IF(HASONEVALUE('table'[TRGT]),
IF(
    [measure]>SUM('table'[TRGT])
    ,"1"
    ,"2"
)
)

 

And this resolved my issues, I cannot thank you enough...

Nanc