Conditional Colour Formatting using 2 different columns in the condition

Hi All,

Thanks in advance.

What I am trying to achieve:

Conditional formatting a cell based on 2 conditions (The value in the cell i want to colour and also in another column).

What I currently have:

• Measures:
  • Total Leave  = SUM(Leave taken on 1st June 2023)
  • Total Timesheet hours = SUM(Timesheet hours submitted for 1st June 2023)
• Then i created 2 checking measures:
  • 1st Check = IF([Total Leave] > 0, 1, 0)
  • 2nd Check = IF([Total Timesheet hours] > 0, 1, 0)
• Then i created a final checking measure:
  • Final Check = IF(([1st Check] + [2nd Check]) > 1, 1,0)
• Then i applied the conditional formatting using "Values" and this is almost what I need, but I found a problem. The final check is not checking row by row for each individual "Staff name" in the list, instead it appears to do the final check by the entire list Grand Total and then applies the colours to the Grand total values instead of each individual staff.

Report Table:

Expected Results:

• IF "Leave taken on 1st June 2023" and "Timesheet hours submitted for 1st June 2023" are both populated (or the sum of both measures is greater than 1, not sure which method to use here), then Colour both cells Salmon Pink, otherwise do not colour.
• Using the table data: For Staff Name = 'Cameron', the cells "Leave taken on 1st June 2023" and "Timesheet hours submitted for 1st June 2023" would both be coloured in a Salmon pink. All other staff will not have any colour.

I hope my explanation is clear.

Thank you