Help Writing a Measure

[JIGAR]

Hello,

I need some help with writing a measure to get the specific desired result.

Please find below the raw data along with the output that I am looking for.

Raw Data : 

Date	Name	Hours	Category
1/3/2020	Sam	7.5	Cat 1
1/2/2020	Sam	7.5	Cat 1
1/4/2020	Sam	5	Cat 1
1/4/2020	Sam	5	Cat 2
1/4/2020	Sam	5	Cat 3
1/4/2020	Sam	5	Cat 4
1/4/2020	Sam	5	Cat 5
1/4/2020	Sam	5	Cat 6
1/2/2020	Sam	7.5	Cat 3
1/2/2020	Sam	7.5	Cat 7
1/3/2020	Sam	7.5	Cat 8
1/3/2020	Sam	7.5	Cat 9
1/3/2020	Sam	7.5	Cat 10
1/3/2020	Sam	7.5	Cat 6
1/2/2020	Sam	7.5	Cat 6
1/3/2020	Sam	7.5	Cat 11
1/3/2020	Sam	7.5	Cat 3
1/2/2020	Sam	7.5	Cat 2
1/3/2020	Sam	7.5	Cat 2

Desired Output :

Output
Name	Total Hours
Sam	20
Cat 1	20
Cat 2	20
Cat 3	20
Cat 4	20
Cat 5	20
Cat 6	20
Cat 7	20
Cat 8	20
Cat 9	20
Cat 10	20
Cat 11	20
Total	20

Output I am getting (This is incorrect)

Name	Total Hours
Sam	20
Cat 1	20
Cat 2	20
Cat 3	20
Cat 4	5
Cat 5	5
Cat 6	20
Cat 7	7.5
Cat 8	7.5
Cat 9	7.5
Cat 10	7.5
Cat 11	7.5
Total	20

The measure that I am looking for should calculate the total no. of hours based on the dates irrespective of task category. 

Any help on this would be highly appreciated

Thank you

[Anonymous]

Pull below measure in your Visual:

SumOfHours=CALCULATE(SUM(Table[Hours]),ALL(Table[Category]))

[jthomson]

Start by explaining the logic that gives, say, Cat 7 = 20. There's one line for Cat 7, and it says 7.5.