Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
in the first sum after the column name you close the function with ) ?
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
I get the below.
Too many arguments were passed to the SUM function. The maximum argument count for the function is 1.
in the first sum after the column name you close the function with ) ?
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |