Forum Discussion

jmuthukumaran's avatar
jmuthukumaran
Frequent Visitor
4 years ago

Background color based on another row

Team ,    I have a matrix report , i need to add background color to "CFR Total" row based on "Target %" row ,something like this  if target % is less than CFR Total for that period then Green els...
Need Help
jmuthukumaran's avatar
jmuthukumaran
Frequent Visitor
4 years ago

Thanks for the reply , if i have multiple countries in column A like China , India etc 

does measure logic change ?

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi jmuthukumaran ,

 

Add the country condition in filter:

Measure2 = 
var target_ = CALCULATE(SUM('test'[Value]),FILTER(ALL('test'),'test'[Period]=SELECTEDVALUE('test'[Period])&&'test'[Details]="Target %"&&'test'[country]=SELECTEDVALUE('test'[country])))
Var total_ =CALCULATE(SUM('test'[Value]),FILTER(ALL('test'),'test'[Period]=SELECTEDVALUE('test'[Period])&&'test'[Details]="Total"&&'test'[country]=SELECTEDVALUE('test'[country])))
return IF(target_<total_,"green","red")


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