Summarize table with added row

[bhalicki]

Hi All,

I have the following tables:

I am looking to produce a table as follows (using DAX):

Adding the TotalHours isn't too difficult, but i'm not sure how to add the "Total" row.

Any help would be greatly appreciated.

Kind regards,

Ben.

[bhalicki]

Thanks @weiqb , nice solution 🙂

[weiqb · Accepted solution]

You can use SUMMARIZE/ROLLUP/ISSUBTOTAL function.

For example.