Sum grouping in Power bi

[TodGrindley]

Hi,

I am fairy new to the power bi world and would like some help with grouping in my matrix table. Below is a photo of what my table currently looks like:

https://www.screencast.com/t/Gg8RALDX

I have highlighted a section which is a grouping of 2 tasks. Is there a way I can get the sum both fields whenever there are 2 tasks in the same group rather than get each individuals value. End result should look similar to this:

https://www.screencast.com/t/AGLwgztLW5

Thanks in advance. 

[v-jiascu-msft]

Hi @TodGrindley,

It seems you have decorated the Matrix. Even if we can get the value 20.60, there are still two rows (cells). Can you share the pbix? Maybe we can find a workaround. You can delete the private contents first.

Best Regards,

Dale

[TodGrindley]

Hi Dale,

I appreciate that. I have been on this all day but cannot find a solution. I have uploaded a copy to the link below:

https://drive.google.com/file/d/1puPlyK2EowrLoCmxcFapdEZQ4JtxpnIm/view?usp=sharing

[v-jiascu-msft · Accepted solution]

Hi @TodGrindley,

Since you used that column as rows in a Matrix, I would suggest you replace it with a new calculated column. 

New taskwork =
CALCULATE (
    SUMX (
        SUMMARIZE (
            'Tasks (2)',
            'Tasks (2)'[projectname],
            'Tasks (2)'[Summary Task (Group)],
            'Tasks (2)'[taskname],
            'Tasks (2)'[taskwork]
        ),
        'Tasks (2)'[taskwork]
    ),
    ALLEXCEPT (
        'Tasks (2)',
        'Tasks (2)'[ProjectName],
        'Tasks (2)'[Summary Task (Group)],
        'Tasks (2)'[TaskName]
    )
)

Please delete the file if necessary.

Best Regards,

Dale

[TodGrindley]

This solution worked for me. Thank you very much for your help!

[Floriankx]

Hello,

you can simply add them

New Measure=[Tank]+[Task Work].

Best regards.