SUM with different at level

[nkasdali]

Hi All,

Let say that i have a table with this structure : Code_Orga, Code_Country, Date, Total_Sales.

I want to know how i can do in dax to get Total_Sales for each Orga, Country and date ?

Thanks for your help

[nkasdali · Accepted solution]

Hi,

Got it ! using the function ALLEXCEPT

🙂

[PattemManohar]

@nkasdali Please try this as a "New Table"

Output = SUMMARIZE(InputTableName,Code_Orga,Code_Country,Date,"TotalSales",SUM(Total_Sales))

[nkasdali]

Hi,

thansk for your help.

Using Summarize will return a new table, in my case i wanted to add a column. 😉