Conditional formating using a Measure
Hi! I created a measure to be used in a Matrix usinf the bellow code: Measure 2 = IF ( ISINSCOPE('Table[nm_mdld]), VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1 VAR grade = SWITCH(TRUE, indx <= 0.01, "1", indx > 0.01 && indx <= 0.05, "2", indx > 0.05 && indx <= 0.10, "3", indx > 0.10 && indx <= 0.20, "4", indx > 0.20, "5") RETURN grade, VAR indx = DIVIDE(SUM('Table'[vl_pe]), sum('Table'[vl_pvs]), 1)-1 VAR grade = SWITCH(TRUE, indx <= 0.01, "1", indx > 0.01 && indx <= 0.05, "2", indx > 0.05 && indx <= 0.10, "3", indx > 0.10 && indx <= 0.20, "4", indx > 0.20, "5") RETURN grade ) I would like to use the value in the Measure 2 e.g. (1,2,3,4,5) to change it´s cell color, but I was unable to find a solution. I´m newbe in DAX . Regards.