Untitled

avatar
unknown
plain_text
4 years ago
561 B
6
Indexable
CondF3 = IF (SelectedValue('CalcGroup'[CalcItem]) = "ACTUAL" ,"#FFE699",	
IF (SelectedValue('CalcGroup'[CalcItem]) = "FCST"  ,"#FFF2CC",	
IF (SelectedValue('CalcGroup'[CalcItem]) = "VAR vs FCST" && [Measure1] > 0,"#BBE3C5",	
IF (SelectedValue('CalcGroup'[CalcItem]) = "VAR vs FCST" && [Measure1]  < 0,"#FCBCBC",
IF (SelectedValue('CalcGroup'[CalcItem]) = "BDGT" ,"#FFF2CC",	
IF (SelectedValue('CalcGroup'[CalcItem]) = "VAR vs BDGT" && [Measure1] > 0,"#BBE3C5",
IF (SelectedValue('CalcGroup'[CalcItem]) = "VAR vs BDGT" && [Measure1] < 0,"#FCBCBC"
	)))))))
Editor is loading...