Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Kaladin
Frequent Visitor

Calculate multiple hour * rate entries for a ticket

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! 

1 ACCEPTED SOLUTION
milanpasschier3
Resolver I
Resolver I

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.

View solution in original post

1 REPLY 1
milanpasschier3
Resolver I
Resolver I

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors