power bi sum by category from another table

For more information, see Context in DAX Formulas. If there is only one level summarization, we can move to the "Name1" argument after mentioning the GroupBy column directly. The SUMX function takes as its first argument a table, or an expression that returns a table. Averages What were the mean sales in this month, by salesperson? Formulas in Power BI can be created using the DAX language.read more. But, there are some cases that are a bit more challenging, like geography. window.dataLayer = window.dataLayer || []; var links=w.document.getElementsByTagName("link");for(var i=0;i