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_Value > HI HI(red), then Current_Value should be color coded to red, else green.

 

I am guessing I have to use the summarize function or values, but can't seem to get the syntax right. Any thoughts?

 


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

     

6 Replies

    • 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
        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