Conditional Formatting error

[salonikhedkar_1]

I do a target table. But it is not a date dimension. Its just a simple table of country, target, month and a concat field, concatenating country and month. Based on this concatenated field, I am joining this target table with my main table.

This works well. But breaks in conditional formatting. I have a measure which supports conditional formatting. the formula is as follows:

TARGET_MEASURE =
var TARGET = SELECTCOLUMNS(TargetTable, "TARGET", TargetColumn)
RETURN

SWITCH(TRUE(),
TARGET>= Amount,1,
TARGET<= Amount,2,
ISBLANK(Amount),3)

------------------------------------------------------------------------------------------
This formula compared target vs amount, if target is higher than amount, then 1.....and so on. 
It worked well when I had a Target column in my existing table. But when I made a separate Target table, it is consideing consition1 and Blanks as 1

[v-juanli-msft]

Hi @salonikhedkar_1 

If you create a seperate target table which has only "target" field and it doesn't has any relationship with your main table, the conditional formatting measure wouldn't work by default.

Please feel free to ask me further.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[salonikhedkar_1]

@v-juanli-msft 

There is a relationship between the two tables. 

[v-juanli-msft]

Hi @salonikhedkar_1 

It is appreciated to share some sample data for further analysis.

Best Regards

Maggie