CALCULATED COLUMN/MEASURE VALUE NOT GIVING THE CORRECT RESULT

[mh2587]

Hi I hope you people doing well 
I am facing very weird issue  regarding division as dividing calculated column by measure value the output is incorrect

CC Cases Ratio =

var CCLT = 'CRM Log'[CC Lead Time]

var CCCases = [CC Cases]

var _Divide = DIVIDE(CCLT,CCCases,0)

return _Divide

[mh2587]

@amitchandak  @parry2k  @smpa01  please you guys help me in this thank you

[amitchandak · Accepted solution]

@mh2587 , You should create a measure, not a column, like

CC Cases Ratio =
var CCLT = Sum('CRM Log'[CC Lead Time]) //Assume this is a column
var CCCases = [CC Cases] //Assume this is a measure
var _Divide = DIVIDE(CCLT,CCCases,0)
return _Divide

[mh2587]

Thank you brother would you please help me why the value is incorrect in calculated column for the learning purpose

[amitchandak]

@mh2587 , for that need to see what you want 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.