Forum Discussion

bhalicki's avatar
bhalicki
Helper V
1 year ago
Solved

Summarize table with added row

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.

 

  • You can use SUMMARIZE/ROLLUP/ISSUBTOTAL function.

    For example.

     

2 Replies

  • weiqb's avatar
    weiqb
    Frequent Visitor

    You can use SUMMARIZE/ROLLUP/ISSUBTOTAL function.

    For example.