Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get total from another table columns

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!

General Comment
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    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.

1 Reply

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    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.