Conditional formating when blank on row

Hi zzinoun ,

I have a test in my side, I find that if I add column from Table1 and column from Table2 in table visual then the conditional formatting won't work for the blank cell. 

My Test:

Return Blank() won't work.

Return "Blank" as a flag works.

Measure 2 = 
VAR _T2 = calculate(MAX('Table 2'[T2 Column1]),FILTER(ALL('Table 2'),'Table 2'[T2 Column1] = MAX('Table 1'[T1 Column1])))
RETURN
IF( _T2 = BLANK(),"Blank",_T2)

So I suggest you to add a blank flag in blank cell from T2. Then create a color measure based on above measure.

Measure = 
IF(MAX('Table 1'[T1 Column1]) in CALCULATETABLE(VALUES('Table 2'[T2 Column1]),ALL('Table 2')),"Blue","Red")

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.