Prorate Category by Day

[shep123]

I need help prorating task hours by day (Daily Hours). I need this to be a measure and not a calculated column. I am pretty sure I am overcomplicating this and it is rather simple.

Task	Day	Total Hours	Daily Hours
A	1/1/20	8	4
A	1/2/20	8	4
B	1/1/20	2	2

[v-jayw-msft · Accepted solution]

Hi @shep123 ,

Check the below measure.

Measure = SELECTEDVALUE('Table'[Total Hours])/CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Task]))

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@shep123 , try a measure like

divide(calculate(max(Table[Total Hours]),allexcept(Table[Task])),calculate(count(Table[Total Hours]),allexcept(Table[Task])))