Divide by Count using a slicer

[Qotsa]

Hi,

I have a table that contains the columns hours & the week number of these hours.

I have a slicer using week number. If I select in the slicer for example -

Weeks 1 to 8

I want to divide the total hours offered in these weeks by 8. (Count of week number)

If I select Weeks 3 to 6 I want to divide total hours offered by 4 etc...

Tried using ALLSELECTED but this doesn't work.

[parry2k · Accepted solution]

@Qotsa try following measure

Avg = 
DIVIDE ( 
SUM ( Table[Hours] ), 
COUNTROWS ( VALUES ( Table[WeekNumber] ) ) 
)

[fhill · Accepted solution]

I agree with the solution above as well.  The table shown to the right is the raw data.  The slicer limits the number of rows and associated Hours to the MEASURE.  If this doesn't work, I'm assuming there's more to your raw data than just these two rows.  Can you post a sample please.
FOrrest

[Qotsa]

Perfect. Works a treat. Thanks a million.

[parry2k · Accepted solution]

@Qotsa try following measure

Avg = 
DIVIDE ( 
SUM ( Table[Hours] ), 
COUNTROWS ( VALUES ( Table[WeekNumber] ) ) 
)