Get total from another table columns

[Abdel_BCN]

Hi!

I have Job's ID's with several amount of hours logged in. I want to get the total the summary of these hours in another table in only one line Job ID -> Total hours.

Until now what I get is repeated total hours.

Thanks!

[v-chenwuz-msft · Accepted solution]

Hi @Abdel_BCN ,

You want get a summarize table which has jobid and total?

Please consider SUMMARIZE(). And in your case some dax like the following:

Total_Billable_Hours =
SUMMARIZE(
    'BU Analysis',
    'BU Analysis'[Job No.],
    "Total_hours", SUM( 'BU Analysis'[Real Hours] )
)

If this does not work, please share pbix file without sensitive data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.