Forum Discussion
Percentaje by month
Anonymous
If you are summarizing, use this method,% By Month = DIVIDE( SUM(Table2[Hours]), CALCULATE( SUM(Table2[Hours]) , ALLEXCEPT(Table2,Table2[Month])) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Example Data
| Month | Client | Hours |
| 1 | C1 | 3 |
| 1 | C2 | 4 |
| 1 | C3 | 6 |
| 1 | C4 | 8 |
| 1 | C1 | 9 |
| 1 | C1 | 10 |
| 1 | C2 | 2 |
| 2 | C3 | 3 |
| 2 | C4 | 5 |
| 2 | C4 | 7 |
| 2 | C2 | 8 |
| 3 | C4 | 12 |
| 3 | C2 | 34 |
Super UserAnonymous
Measure to calculate the % of Total Hours by Month:
% Hours By Month =
DIVIDE(
SELECTEDVALUE(Table1[Hours]),
CALCULATE( SUM(Table1[Hours]) , ALLEXCEPT(Table1,Table1[Month]))
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Thanks a lot now iw working!, but when i tried summarize the hours the measure show errors. Thanks al ot by the help
- Fowmy
Anonymous
If you are summarizing, use this method,% By Month = DIVIDE( SUM(Table2[Hours]), CALCULATE( SUM(Table2[Hours]) , ALLEXCEPT(Table2,Table2[Month])) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Thanks a lot by the help