Conditional formatting based on two other columns

[Kimia79]

Hi,

I need to write a formula for this table based on two other columns, one column has text format and the other has value.

e.g. If the pattern is Current and the value is 1 assign 1. If the pattern is online and the value is 1 assign 2. If the pattern is current and the value is 0 assign 0. else assign 3.

Can anyone help me?

[v-luwang-msft]

Hi @Kimia79 ，

Like Sara.v ,subject1 ,currect and  online all is 1,output is 1+2=3?

Could you pls show the output result you expected?

Best Regards

Lucien

[amitchandak]

@Kimia79 , You can a color meausre, You can use dimesion value with max() or min () or FIRSTNONBLANK or LASTNONBLANK and measures. Use that in measure conditional formatting using field value option

example

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4