Subtotal in a Row

Question

Hello,I would like to do something like this:Day&nbsp; &nbsp; &nbsp; Label&nbsp; &nbsp; &nbsp; &nbsp;Hours01.01&nbsp; &nbsp; &nbsp; &nbsp;R&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 201.01&nbsp; &nbsp; &nbsp; &nbsp;I&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;201.01&nbsp; &nbsp; &nbsp;Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp;I got hours per Day that are split per Label. What I need is the total amount of hours per Day in an extra row. Is that possible?&nbsp;RegardsDennis

v-ljerr-msft · Accepted Answer

Hi&nbsp;dennis1994,
&nbsp;
Based on my test, you should be able to follow steps below to get the expected result.
&nbsp;
1. Add new table with a single column like below to your model(make sure there is no any relationships between this table and the other tables).
&nbsp;

&nbsp;
2. Use the formula below to create a new measure.
Measure = 
VAR lable =
    MAX ( Table2[Label] )
RETURN
    IF (
        lable = "Total",
        SUM ( Table1[Hours] ),
        CALCULATE ( SUM ( Table1[Hours] ), Table1[Label] = lable )
    )

&nbsp;
3. Show 'Day' column, 'Lable' column from the new added table, and the measure on Table visual.
&nbsp;

&nbsp;
Here is the sample pbix file for your reference.&nbsp;:smileyhappy:
&nbsp;
Regards

Forum Discussion

Subtotal in a Row

2 Replies

Related content

Row subtotals blank

Add subtotal Rows

Rows without data showing subtotals

Customize subtotal in matrix

Row subtotal did not match