Untitled
unknown
plain_text
5 years ago
854 B
12
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...