group customers in a column

Lana 1 Reputation point
2021-03-08T13:27:36.257+00:00

Hi Community, I am stuck with the problem, in one column there're different customers, in another one - different values. I need to group customers and sum up values for the groupped customers, show this in a Matrix in Power Bi, but actually nothing's working, creating more and more errors. I would like to see in columns Customer and values subtotal (like in columns E,F on a screenshot). Thanks in advance

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,260 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-03-09T02:21:38.17+00:00

    Hi,

    Was this a DAX or MDX issue ? Since you are using Power BI, I guess this is a DAX issue.

    You just want to creat a sum table that is grouped by custermer right ?

    Try this table expression :

    Amount Ordered by Customer =
    SUMMARIZE (
        TableName,
        Customer[TableName],
        "Amount Ordered", SUM( Amount Ordered[TableName] )
    )
    

    Regards,
    Lukas