Forum Discussion

shep123's avatar
shep123
Icon for Helper I rankHelper I
6 years ago
Solved

Prorate Category by Day

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

shep123 , try a measure like

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