Trying to Divide into a Measure or Average it

[andy808]

I created 2 measures:

1 - # of Paid Days = CALCULATE(DISTINCTCOUNT(ASTimeEntry[TimeRecordedOnDate]),(FILTER('Date Table','Date Table'[IsWeekend] = False ))) + 0

2 - Sum of Tracked Hours = SUM(ASTimeEntry[TrackedHours]) +0

To get a %, I divided them:

Total Paid Hours % = [Sum of Tracked Hours] / [Total Paid Hours]

When I slice for 1 person it works (eg 100%). When I use it for the whole team (5 people) - it ADDS the %s (eg 500%). How do I average this %? Average FXN doesnt work, divide FXN by # of people doesnt work. Or is there a completely different formula I need to create?  HELP!

[amitchandak · Accepted solution]

@andy808 , make sure date does not have timestamp

or

try like

calculate( averageX(values(ASTimeEntry[TimeRecordedOnDate]), calculate(SUM(ASTimeEntry[TrackedHours]))),FILTER('Date Table','Date Table'[IsWeekend] = False()))

[andy808]

Thank you! I posted a new Q last night 2/28, could you look at it?

I am trying to get the % by dividing 1 result in a column over a TOTAL # from another column that is fixed/that doesnt get filtered except by Date slicer.

Right now I am getting 311/1328 (for a particular date range) which is the result I need:

The measure for Total Paid Hours ALL is: 

Total Paid Hours ALL = CALCULATE([Total Paid Hours], ALL())
-------------------------------------------------------------------------------- 
***Here is my [Total Paid Hours] measure which already has a filter = 
 = CALCULATE(DISTINCTCOUNT(ASTimeEntry[TimeRecordedOnDate]),(FILTER('Date Table','Date Table'[IsWeekend] = False ))) *8

But when I change my Date slicer the Total Paid Hours ALL is not changing.

 Appreciate any help here as soon as possible, thank you.