DAX: Divide and exlcude if value less than

[vincentakatoh]

Hi, 

Will like to write update the Divide DAX to return "null" if [InputFn]<=10, 

original dax

FnDR = DIVIDE(sum(Data[FnFailCount]),Data[InputFn],1)

1st Attempt: but return weird results 

FnDR = IF(Data[InputFn]>10,DIVIDE(sum(Data[FnFailCount]),Data[InputFn],1),"null")

2nd attempt: but got error message

FnDR = calculate(DIVIDE(sum(Data[FnFailCount]),Data[InputFn],1), Data[InputFn]>10)

[nickchobotar · Accepted solution]

@vincentakatoh

Please give a try to this one

FnDR = IF(SUM(Data[InputFn])>10,DIVIDE(SUM(Data[FnFailCount]),SUM(Data[InputFn]),0),BLANK())

N -