Conditional Formatting Colour Scale Not Shading Correctly

[CaveOfWonders]

Hi All,

I created the Stacked Bar Chart below based on one categorical Field with 4 distinct values and dropped a measure into the Value box and attempted to apply conditional formatting based on the count. As you can see there seems to be something wrong here as the top bar (A) is a lighter shade of purple than the bar below it (B). Why is this not shading correctly?

The calculation of the measure being used:

Field =
CALCULATE (
  COUNTROWS (
    FILTER (
       'Table 1',
       'Table 1'[Completion Date] <> BLANK ()
       && 'Table 1'[Completion Date] < 'Table 1'[Planned Completion Date])))

Chart

Conditional Formatting:

Measure:

[amitchandak · Accepted solution]

@CaveOfWonders , I doubt it used correctly. It should ask aggregation for the measure. Have taken correct measure

[CaveOfWonders]

Should I be using the Measure as the Count? I am currently using the Categorical field?