Need help to write a multi switch condition dax

[Anonymous]

Hello All,

Trying to create a traffic signal kpi.

For that i have two parameteres to calculate as below image.

Parameter	Red	Amber	Green
Contribution	Less than 0%	>0% and <10% of deal	>= 10%
Billed Utilization	<85%	<92% and > 85%	>=92%

First i have written Dax calculated column for only contribution condition as below

Traffic = SWITCH(TRUE(),
	Contri_Aug[Contri]<=0.00,"https://cdn3.iconfinder.com/data/icons/developperss/PNG/Red%20Ball.png",
    Contri_Aug[Contri]>=0.10,"https://cdn3.iconfinder.com/data/icons/developperss/PNG/Green%20Ball.png",
	Contri_Aug[Contri]>0.00 && Contri_Aug[Contri]<0.10,"https://cdn3.iconfinder.com/data/icons/developperss/PNG/Yellow%20Ball.png",
	
	BLANK())
    

It worked perfectly for me.

Then i have tried to write the same by including for builled utilization also as below.

Traffic2 = SWITCH(TRUE(),
	Contri_Aug[Cotnri]<=0.00 && [_BU]<0.85, "https://cdn3.iconfinder.com/data/icons/developperss/PNG/Red%20Ball.png",
    Contri_Aug[Contri]>=0.10 && [_BU]>=0.92,"https://cdn3.iconfinder.com/data/icons/developperss/PNG/Green%20Ball.png",
	Contri_Aug[Contri]>0.00 && Contri_Aug[Contri] < 0.10 && [_BU]<0.92 && [_BU]>0.85,"https://cdn3.iconfinder.com/data/icons/developperss/PNG/Yellow%20Ball.png",
	
	BLANK())

But it giving me wrong result.

Can anyone help me to get this done.

Thanks,

Mohan V

[TomMartens]

Hey,

you may try this

SWITCH(TRUE()
,AND(condition1, condition2), ...
,AND(condition1, condition2), ...
,AND(AND(condition1, condition2),condition3), ...
)

Hope this will help

Regards

Tom

[Anonymous]

Thanks for the quick reply @TomMartens.

I tryied this but the result is same as previous.

Traffic2 = 
SWITCH(TRUE()
,AND(Contri_Aug[Contri]<=0.00 ,[_BU]<0.85), "https://cdn3.iconfinder.com/data/icons/developperss/PNG/Red%20Ball.png"
,AND(Contri_Aug[Contri]>=0.10, [_BU]>=0.92), "https://cdn3.iconfinder.com/data/icons/developperss/PNG/Green%20Ball.png"
,AND(AND(AND(Contri_Aug[Contri]>0.00, Contri_Aug[Contri]<0.10),[_BU]<0.92),[_BU]>0.85), "https://cdn3.iconfinder.com/data/icons/developperss/PNG/Yellow%20Ball.png"
)
    

[Anonymous]

Hi @Anonymous,

If you can, please provide the pbix file with sample data for further testing.

Regards,

Xiaoxin Sheng