Conditional formatting on another column

[h4_dkj]

Hi

I am trying to conditional format my finance result each month compared to the budget

The table 

Comapany	Finance mont 1	budget mont 1	Finance month 2	budget month 2	Finance month3	budget month 3
1	- 5	-4,5	-4.1	4,5	-6	-5,2

I have created a KPI Color DAX:

KPI_1_1_Color = IF(SUM('BUDGET_COMMITMENTS (2)'[KPI_1_1_Virkelig]) > SUM('BUDGET_COMMITMENTS (2)'[KPI_1_1_Budsjett]), "#69b00b"

,"#f44242"

)

I then use this on my visual and choose conditional formatting. Setting background color to my measure.

Then apply it.

 

The table should look like this

Comapany	Finance mont 1	budget mont 1	Finance month 2	budget month 2	Finance month3	budget month 3
1	- 5	-4,5	-4.1	4,5	-6	-5,2

How ever the finance month 2 get the color green as wel. It should be red.

Any ideas on what I am doing wrong?

[V-lianl-msft]

Hi @h4_dkj ,

DAX measure is based on the current row context, it is recommended that you check that your model meets the requirements for using this measure. 

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.