Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Need help to write a multi switch condition dax

Hello All,

 

Trying to create a traffic signal kpi.

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

 

ParameterRedAmberGreen
ContributionLess 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

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Anonymous,

         

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

         

        Regards,

        Xiaoxin Sheng