Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
7 years ago
Solved

SUM with different at level

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

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • PattemManohar's avatar
    PattemManohar
    Community Champion
    7 years ago

    nkasdali Please try this as a "New Table"

     

    Output = SUMMARIZE(InputTableName,Code_Orga,Code_Country,Date,"TotalSales",SUM(Total_Sales))
    • nkasdali's avatar
      nkasdali
      Microsoft Employee
      7 years ago

      Hi,

      thansk for your help.

       

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

  • nkasdali's avatar
    nkasdali
    Microsoft Employee
    7 years ago

    Hi,

     

    Got it ! using the function ALLEXCEPT

     

    :)