if and switch statement in measure

[aravindh10]

i am not able to write switch and if in meaure.someone help me with example

i am able to write it in column 

Slab = IF((APL[APL.ITEM_STATUS_CD] <>"C" && [Due Days] <0 ),"Overdue",

IF((APL[APL.ITEM_STATUS_CD] <>"C" && ([Due Days] >= 0 && [Due Days] <31)),"0-30",

IF((APL[APL.ITEM_STATUS_CD] <>"C" && ([Due Days] > 30 && [Due Days] <61)),"31-60",

IF((APL[APL.ITEM_STATUS_CD] <>"C" && ([Due Days] > 60 && [Due Days] <91)),"61-90",

IF((APL[APL.ITEM_STATUS_CD] <>"C" && ([Due Days] > 90 )),">90",

IF(APL[APL.ITEM_STATUS_CD] ="C","Payment"))))))

[v-danhe-msft · Accepted solution]

Hi @aravindh10 ,

You could try to use below formula:

Slab = IF((CALCULATE(MAX(APL[APL.ITEM_STATUS_CD])) <>"C" &&CALCULATE(SUM( [Due Days])) <0 ),"Overdue",
IF(CALCULATE(MAX(APL[APL.ITEM_STATUS_CD])) <>"C" && CALCULATE(SUM( [Due Days]))>=0&& CALCULATE(SUM( [Due Days]))<31,"0-30"))

Result:

Regards,

Daniel He