Forum Discussion

TodGrindley's avatar
TodGrindley
Frequent Visitor
8 years ago
Solved

Sum grouping in Power bi

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. 

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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

5 Replies

  • Floriankx's avatar
    Floriankx
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hello,

     

    you can simply add them

     

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

     

    Best regards.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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