Conditional Formatting for not-equal to a summary value

BrianJ · October 1, 2019, 1:53am

Lots of different ways to handle this one. Similar approach using measures and Rules conditional formatting:

Fully Allocated Single Color = 
    IF( [% Allocated] = 1, 1, 0 )

And if you care about the distinction between < 100% and >100%:

Fully Allocated Dual Color = 
SWITCH( TRUE(),
    [% Allocated] = 1, 1,
    [% Allocated] < 1, 0,
    2
)