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 have a problem calculating the percentage of several departments that belong together. When I use filters, the average is the number of departments, not the time / absence of all departments.
If i have this file, how do I get it right. I want to filter between Main dept and down to specifik dept?
I wan´t to calculate absence short/worktime and the same for long. I don´t want to sum all the rows percent, I want to calculate the percentage of all rows that belong together if I filter on it.
Date | Dept | Main Dept | Absence short | Absence Long | Worktime |
Jan | 9103 | Sales | 623,2 | ||
Jan | 9104 | Sales | 139,6 | 5202,0 | |
Jan | 9106 | Sales | 32,8 | 934,8 | |
Jan | 9107 | Sales | 52,1 | 5194,3 | |
Jan | 9111 | Marketing | 656,0 | ||
Jan | 9117 | Marketing | 68,8 | 5196,4 | |
Jan | 9118 | Marketing | 41,0 | 1008,0 | |
Jan | 9119 | Marketing | 168,9 | 41,0 | 4827,2 |
Solved! Go to Solution.
@Anonymous , expected output is not clear. can you share that.
Try a measure like divide(sum(Table[Absence]), sum(Table[Worktime]))
@Anonymous , expected output is not clear. can you share that.
Try a measure like divide(sum(Table[Absence]), sum(Table[Worktime]))
now I realize this was exactly as easy as I thought it would be. Thanks
(I am a biginner so sorry)
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |