Formatting Table Visual Cell Background Color based on Other Column Values

[prabhatnath]

Hi Friends,

I am new to PBI and working on some reports where I have below table data loaded into PBI that I am showing in a Table visual. 

ID	Type	SP
1002	User Story	3
1003	Task
1004	Task
1005	Task
1006	User Story	2
1007	Task
1008	Task
1009	Bug	1
1010	User Story
1011	Task
1012	User Story	1
1013	User Story
1014	User Story	2
1015	Task
1016	Bug

I want the SP column in the table visual to have specific background color as per the below conditions:

If the Type = User Story OR BUG and SP is NOT Blank (having any positive value) then the SP cell background color should be GREEN
If the Type = User Story OR BUG and SP IS Blank then the SP cell background color should be RED
if the Type <> User Story OR BUG then the SP cell background color should be a GRAY color.

Expected visual:

Please suggest.
Thanks,
Prabhat

[ddpl · Accepted solution]

@prabhatnath Creeate measure as per below:

Measure 2 = var _type = MIN('Table (2)'[Type])
            var _sp   = MIN('Table (2)'[SP])
            return
                IF((_type = "User Story" || _type = "Bug") && _sp >0 , 1,
                IF((_type = "User Story" || _type = "Bug") && _sp = BLANK() , 2,
                IF((_type <> "User Story" || _type <> "Bug") ,3,0)))

 Then assign conditional formating as per below:

Please accept as solution if its worked.