nested if condition

[sakshikaul]

Hi,

I want in following DAX when denominator is 0 and numerator is some value I am getting result as infinity so I want instead of infinity I should get value as blank or -

Please help

GP Yeild KG = var prodA=if(CALCULATE(round(Sum(DBALLSTAT[Profit]),0))/CALCULATE(round(Sum(DBALLSTAT[ChglWt(KG)]),0), Group_Logic[Mode_group_3]="AIR"),if( CALCULATE(round(Sum(DBALLSTAT[Profit]),0))/CALCULATE(round(Sum(DBALLSTAT[Tues]),0)+CALCULATE(sum(DBALLSTAT[CBM])/25), Group_Logic[Mode_group_3]="OCEAN"),CALCULATE(round(Sum(DBALLSTAT[Profit]),0))/CALCULATE(round(Sum(DBALLSTAT[ChglWt(KG)]),0))))return prodA

[v-xulin-mstf · Accepted solution]

Hi @sakshikaul,

You can try this in your measure:

if(Denominator=0,blank(),Molecular/Denominator)

Best Regards,

Link

[amitchandak]

@sakshikaul , use divide function

example

divide(sum(Table[col]), sum(Table[Col2]))

[sakshikaul]

This will not resolve my purpose as I want for eg - 7/0 = infinity , instead of infinity I want result should be Blank 

[amitchandak]

@sakshikaul , I tried

Measure = divide(7,0)

and it gives a blank. Means you will blank in place of infinity 

if you need 0 then try

Measure = divide(7,0,0)

means
Measure = divide([measure1],[Measure2],0)

[sakshikaul]

Hi,

I am getting following error. Please help 

[sakshikaul]

Hi,

I need below expression to work but its not working.

GP Yeild KG = var prodA=CALCULATE(Sum(DBALLSTAT[Profit]))/CALCULATE(Sum(DBALLSTAT[ChglWt(KG)]),Group_Logic[Mode_group_3]="AIR") var prodB=CALCULATE(Sum(DBALLSTAT[Profit]))/CALCULATE(Sum(DBALLSTAT[Tues]),Group_Logic[Mode_group_3]="OCEAN") var ProdC=CALCULATE(Sum(DBALLSTAT[Profit]))/CALCULATE(Sum(DBALLSTAT[ChglWt(KG)])) var ProdD=divide(prodA,prodB,ProdC) return ProdD