DAX to compare two columns and set color for the KPI column

[deb_power123]

Hi All,

I have an employee table with Salary ,employee and benchmark columns  . 

I need to compare the benchmark column with Salary column and if Salary > benchmark then KPI color column should be Green, If Salary < benchmark then KPI color column should be Red and if Salary = benchmark then KPI color column should be Yellow.

Could you please suggest any DAX to handle this ? I need to show the KPI color column as shown below in expected output screenshot.

My Source input Table is as below :-

Salary	Benchmark	KPIColor	Employee
20000	15000	Green color should be filled	E1
10000	15000	Red color should be filled	E2
15000	15000	Yellow color should be filled	E3

Expected output :-

Kind regards

Sameer

[Jihwan_Kim · Accepted solution]

KPI color =

SWITCH(TRUE(),

[Salary Total :] > SUM('Table'[Benchmark]), "Green",

[Salary Total :] = SUM('Table'[Benchmark]), "Yellow",

[Salary Total :] < SUM('Table'[Benchmark]), "Red")

Link to the sample pbix file