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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Tom,

 

ConditionalTest.pbix

Please find the link attached.

 

Just to show what I am trying, here is a DAX that is giving me syntax error:

Conditional_Value = If(HASONEVALUE('Table A'[NAME]),
SWITCH(VALUES('Table A'[NAME]),
[Current_Value]>SUM('Table B'[HI HI (red)]), "#FF0000",
[Current_Value]>SUM('Table B'[HI HI (red)]),"#008000"
)
)
TomMartens's avatar
TomMartens
Super 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
    7 years ago

    My god! That was literally my first attempt, but I was formatting it incorrectly!! Thank you so much!!

    • TomMartens's avatar
      TomMartens
      Super User
      7 years ago

      :smileywink:

  • 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