Forum Discussion

muelledg's avatar
muelledg
New Member
1 year ago
Solved

sum by group

I have a column, hours, that I want to sum by another column, Summary. See below for example.   Hours Summary 7 Architect 8 Sales 7 Sales 9 Architect 6 Architect 4 Engin...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi muelledg 

     

    Perhaps the request was not clear enough in my previous reply.

    We need to know what data is being used in the measure you are having problems with (not limited to relationships between tables). Based on the screenshot, we are not sure [summary] [index] [hours] correspond to which fields in your actual data.
    Please share your pbix file if you don't mind. This is the quickest way for us to understand your problem. Alternatively, please provide the dummy data in tabular form that maintains the same data structure as the three actual data tables.

    Thank you for your understanding.

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    How to provide sample data in the Power BI Forum - Microsoft Fabric Community

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.