Forum Discussion

dennis1994's avatar
dennis1994
Frequent Visitor
8 years ago
Solved

Subtotal in a Row

Hello, I would like to do something like this: Day      Label       Hours 01.01       R              2 01.01       I               2 01.01     Total           4   I got hours per Day that are ...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi dennis1994,

     

    Based on my test, you should be able to follow steps below to get the expected result.

     

    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).

     

     

    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 )
    )

     

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

     

     

    Here is the sample pbix file for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi dennis1994,

 

Based on my test, you should be able to follow steps below to get the expected result.

 

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).

 

 

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 )
    )

 

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

 

 

Here is the sample pbix file for your reference. :smileyhappy:

 

Regards