if condition dax logic

[Sathvik123]

Hello All,

I have dax logic below and I need to check one condition before it and if that has the value 'AMRS' then 0 else I need to execute below logic

if region='AMRS' then 0 else my below condition should execute.

Not sure how to write it..

Could any one please help

KPIChatTime = SWITCH(TRUE(),

[Chatmins] <=20, 5,

 [Chatmins] <=25  , 4,

 [Chatmins] <=27, 3,

 [Chatmins]  <=30, 2,

1)

[Anonymous · Accepted solution]

You could just nest that whole thing in an IF() statement. Like, basically what you wrote:

IF( region='"AMRS", 0,

SWITCH(TRUE(),

[Chatmins] <=20, 5,

 [Chatmins] <=25  , 4,

 [Chatmins] <=27, 3,

 [Chatmins]  <=30, 2,

1)

)