Untitled

Anonymous
plain_text
01/20/2021 8:38 AM
1.1 KB
26
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...