Calculation Group - Conditional Colour Formatting - Conflict Color Rule

[Aideekub]

Dear, Community 

I have some problem about condition format after i use calculation group as detail below,

On hightlight that is conflict color that I setting in rule.

Here is rule I set.

and this is condition measure

If need more information please let me know.

[Aideekub]

This is I expected as detail below,

This column builded by individual measure.

SumMTD = CALCULATE([SumActAFC],DATESMTD(DCalendar[Date]))

SumMTD Previous = CALCULATE([SumMTD],DATEADD(DCalendar[Date],-1,MONTH))

%IncreaseMTD = IFERROR(([SumMTD]-[SumMTD Previous])/ABS([SumMTD Previous]),SIGN([SumMTD]))

% Change Month to Date = CALCULATE([%IncreaseMTD],ALLSELECTED(DCalendar[Year&Month2])) << for rule condition formating

[amitchandak]

@Aideekub , Use only the Number option if it is a percent column and use a value between 0 to1

The percentage is for the distribution

refer: Power BI why Rule Based conditional formatting does not work with percent column- Power BI why Rule Based conditional formatting does not work with percent column

[Aideekub]

That took reset after I set this criteria in rule as this below,

or this rule

here still same result. (that incorrent number and percentage same as color)