calculating the percentage of several departments that belong together

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , expected output is not clear. can you share that.

Try a measure like divide(sum(Table[Absence]), sum(Table[Worktime]))

[Anonymous]

now I realize this was exactly as easy as I thought it would be. Thanks 

(I am a biginner so sorry)