simple division formula

[PowerBIBeginer]

Hello All,

I'm in one small confusion, pls guide.

CP = (Table1[WO]) / (Table2[TA])

table1 and table2 are table's. I want to devide WO column value from table1 devided by TA column from Table2..

how to get this

[aj1973 · Accepted solution]

Hi @PowerBIBeginer 

Are Table1 and Table2 related? if so 

CP = DVIDE(SUM(Table1[WO]), SUM(Table2[TA]), BLANK())

[SanketBhagwat]

Hi @PowerBIBeginer .

Use CP=DIVIDE(Table1[WO]),Table2[TA])

If this post helps, then please mark it as Accept as Solution.