Sum of Total hours in the next column

[askspepsi]

Dear All,

I have the below Table and I wanted to add the total hours for one employee in month-wise and add in the next column and calculate the CTC allocation according, Please help me I tried every possible I know.

My Table

Id	Month	Hours	CTC
1	Jan	10	1000
1	Jan	5	1000
1	Feb	25	1100
1	Feb	10	1100
2	Feb	10	1300
2	Feb	15	1300
2	Mar	30	1500
2	Mar	40	1500

Desired Output

Id	Month	Hours	CTC	Total Hours	CTC Allocation
1	Jan	10	1000	15	666.67
1	Jan	5	1000	15	333.33
1	Feb	25	1100	35	785.71
1	Feb	10	1100	35	314.29
2	Feb	10	1300	25	520.00
2	Feb	15	1300	25	780.00
2	Mar	30	1500	70	642.86
2	Mar	40	1500	70	857.14

[Fowmy · Accepted solution]

@askspepsi 

Add the following column:

Column = 
DIVIDE(
    Table4[CTC],
    CALCULATE(
        SUM(Table4[Hours]),
        ALLEXCEPT(Table4,Table4[Id],Table4[Month])
    )
) * [Hours]

[Jihwan_Kim · Accepted solution]

Hi, @askspepsi 

Please check the below picture and the sample pbix file's link down below.

It is for creating measures, not columns.

Total Hours Measure =

CALCULATE (

SUM ( 'Table'[Hours] ),

ALLEXCEPT ( 'Table', 'Table'[Id], 'Table'[Month] )

)

CTC Allocation =

SUM('Table'[CTC]) * (SUM('Table'[Hours]) / [Total Hours Measure])

https://www.dropbox.com/s/ximr9a99mhme9dg/askspepsi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Fowmy · Accepted solution]

@askspepsi 

Add the following column:

Column = 
DIVIDE(
    Table4[CTC],
    CALCULATE(
        SUM(Table4[Hours]),
        ALLEXCEPT(Table4,Table4[Id],Table4[Month])
    )
) * [Hours]