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,
can you please prepare a pbix wiht some sample data, upload the pbix to onedrive or dropbox and share the link.
But in the meantime this might also help: https://community.powerbi.com/t5/Desktop/Using-IF-Statement-for-Date-to-Separate-Dollar-Amounts-in-other/m-p/654372#M313944
Regards,
Tom
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
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
My god! That was literally my first attempt, but I was formatting it incorrectly!! Thank you so much!!