SetAnalysis issue - how to compare two dimensions

[#1]

Dear Community,

I'm new person here still learning new thing, and I'm struggling with SetAnalysis function.

I have set of data - fact table storing how much time each request spend in department

And dimension, saying to which department this request is currently signed.

What i need to find is number of request which are in current department for defined period of time ( below 4 hours, 4-8 hours, above 8 hours).

So i would like to get following results:

Dept	Below 4h	4-8	Above 8
A	1
B	1	1
C			1

I tried to write sum function, calculating time spent only for current department, but such syntax doesn't return me correct values:

Sum({$<DayID-=P({1<DepartmentID={$(=CurrentDepartmentID)}>}DayID)>}[Time Spent in h])

I'm attaching file with simple data.

I'll be very gratefull for your help.

Regards,
Greg

[#2]

This is what I need.

Sunny and Pooja, thank you very much for your help !