Untitled

mail@pastecode.io avatar
unknown
plain_text
3 years ago
561 B
4
Indexable
Never
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"
	)))))))