Problems with CALCULATE + ALLSELECTED in conditional formatting of the cell

[AlenaSK]

Hi!

I'm trying to use a measure for conditional formatting for the cell of the table. 

The table consists of GeoHierarchy & LeadCategory as rows and KPIs as columns.

The filter dashboard is used for GEO hierarchy filters.

The logic is like this: the background of the cell for each rate should change color based on the value of the regional KPI.

I have 2 similar tables: for one the measure works, but for another - no.  I don't understand why.

The measure which works for background of 'Won Opportunity Rate':

Color WOR LPM = If([Won Oppty Rate]<Calculate([Won Oppty Rate], ALLSELECTED('All GEO hierarchy')), "#999999","#2BC275")

So the filter is for AMER region, and each regional KPI is compared with the total value of 18%.

The second table is built with the same rows, but different KPIs as columns. But the measure doesn't work.

Here is the measure for 'Lead to Opp Conversion rate':

Color LTO = If([Lead to Oppty Conversion Rate]<Calculate([Lead to Oppty Conversion Rate], ALLSELECTED('All GEO hierarchy')), "#999999","#7f80ff")

So here background should depend on total of 42%, but it is not responsive and is the same for all regions.

I don't know what can be the reason?