Conditional Formatting on a per value basis in table

You can achieve this by different simple options. 

Option A: 

Apply the conditional format by rules as you mention it. Since data will be on a table, aggreation won't matter because data will be at a row level thus you will have the cell value. That's the easiest one.

Option B: 

Go to Power Query and add a conditional column where" if column with x value is greather than 0 then:" you add the HEX code for red (#FF0000) else white (#FFFFFF). 

Then, apply conditional format by field value and select the column with the HEX codes.

Option C:

Create a DAX measure with the following structure:

MeasureForFormat =

var cell_value = SELECTEDVALUE([ColumnWhereYourNumberIs])

Return

IF(cell_value > 0, "#FF0000", "#FFFFFF")

Then, apply conditional formmating by field value and use this measure as field value. 

I hope this helps 🙂