Untitled

avatar
unknown
plain_text
4 years ago
854 B
9
Indexable
Switch(true(),
    ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = "ACTUAL","#FFE699",
	ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = "FCST","#FFF2CC",
	ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = "VAR vs FCST" && selectedmeasure() >= 0, "#BBE3C5",
	ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = "VAR vs FCST" && selectedmeasure() < 0, "#FCBCBC",
	ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = 	"BDGT" ,"#FFF2CC",
	ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = "VAR vs BDGT" && selectedmeasure() >= 0, "#BBE3C5",
	ISSELECTEDMEASURE ( [MeasureName] ) && SelectedValue('CalcGroup'[CalcItem]) = "VAR vs BDGT" && selectedmeasure() < 0, "#FCBCBC",
	"#FFE699")
Editor is loading...