Help with Division

[rosscortb]

Hello,

I want to create a column that shows

Total Absence Days by month divided by Total Headcount by month.

I have so far. Any help would be appreciated.

Total Days Lost Per Person = CALCULATE(SUM('DB Absence'[Total absence days]('Month'[Month]/CALCULATE(Sum('DB Headcount'[ID]('Month'[Month]))))))

Thanks

Ross

[rafaelmpsantos]

Only this

divide(SUM('DB Absence'[Total absence days]),Sum('DB Headcount'[ID]))

You will use MONTH in X axis of a chart or in the column item for a matrix or table, not in the measure syntax

[rosscortb]

I get the below.

Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.

[rafaelmpsantos · Accepted solution]

in the first sum after the column name you close the function with ) ? 

[rosscortb]

Hi 

I dont think that's what I am looking for I think it might be CountRows for the headcount piece?

divide(SUM('DB Absence'[Total absence days]),Countrows('DB Headcount'[ID]))

[rafaelmpsantos]

use distinctcount