Forum Discussion
Divide two columns using DAX
I'm trying to divide two columns by using DAX. I've always struggled with this functionality in the past and thought I got this but I can't get my head around why it wouldn't work. The formula doin...
Anonymous so as per your screen shot, you need to change data type to decimal number and decimal point to 2 or 3, didn't seems like you did that?
Anonymous did you checked the data type
I did both parry2k , a calculated column and measure using same formulas:
Column formula: Column = DIVIDE(count(Disputes[Disputes]),count(Disputes[Transactions]))
Measure formula: Measure = DIVIDE(count(Disputes[Disputes]),count(Disputes[Transactions]))
Output:
Anonymous so as per your screen shot, you need to change data type to decimal number and decimal point to 2 or 3, didn't seems like you did that?