Different colors at total rows - metrix visual

Hi FreemanZ, thanks for the quick reply, I'll add more.

Hi Anonymous ,

Please use the 'ISINSCOPE' function to determine the row level. Then work with the conditional format to set the color.

ISINSCOPE function (DAX) - DAX | Microsoft Learn

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Measure = 
VAR _level1 = ISINSCOPE('Table'[level1])
VAR _level2 = ISINSCOPE('Table'[level2])
VAR _level3 = ISINSCOPE('Table'[level3])
RETURN 
SWITCH(TRUE(),
_level3 = FALSE() && _level2 = TRUE(),"red",
_level2 = FALSE() && _level1 = TRUE(),"green",
"Yellow"
)

Final output

Best Regards,
Wenbin Zhou