Calculate multiple hour * rate entries for a ticket

[Kaladin]

Hello i am new to DAX and trying to calculate a total cost to a ticket. My table looks like this 

TicketID    Company      Hours  Hourly Cost
   1        comapny a      1     100
   1        comapny a      0.5   125
   2        Company b       5     50
   3        Company c       2     150
   3        Company c       1     125
   3        Company c       3     75

Each ticket can have multiple entries with different costs. I am looking for the total cost of each Ticket. 

I have tried using 

cost = [hours] * [hourly cost] but it errors and says a single value for the column cannot be determined. I have been messing with sum and sumx but cannot figure out the right formula to come up with one cost value for the ticket as a whole. Any help in the right direction is appreciated. Thanks! 

[milanpasschier3 · Accepted solution]

Hello, can you have a look at this?

https://drive.google.com/drive/folders/1CO5accqcXUeUUvlqeRNTG-xFKAmsOSLJ?usp=sharing

Best,

Milan

PS, mark my answer as solution if it fits your needs.